I have recorded a macro to create a range name labeled ‘MARDATA’. I want the range to be from ‘A6’ through to the end of my spreadsheet, the end position changing when I re-import data.
Unfortunately it records the reference in an absolute manner. Can someone tweak / overhaul this code please…
Sheets(“Before”).Select
Range(“A6″).Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
ActiveWorkbook.Names.Add Name:=”MARDATA”, RefersToR1C1:= _
“=Before!R6C1:R500C12”