Defining range names
Posted by Ian Bartlett on February 24, 2001 11:40 AM
I wish to use a macro to assign a range name to a column of figures of variable length; using the macro recorder results in a specific number of cells being defined in the code, as follows:
ActiveWorkbook.Names.Add Name:="Date", RefersToR1C1:="=Data!R8C8:R14C8"
Can I replace "=Data!R8C8:R14C8" with the current selection?