Syntax - Add Range Name based on Selection

B

Bruce Roberson

What is the proper syntax for adding the name "Area1" in
this case, based on a selection of the active cell,
xldown. I recorded it but of course it recorded actual
R1C1 of the range at the time. That doesn't work since the
range will vary in size each time it is run.

So, I need to go something like this.

ActiveWorkbook.Names.Add Name:="AREA1" _
Range.(Selection, Selection.End(xlDown))

Thanks,


Bruce
 
B

Bruce Roberson

Looks like I tried to make it harder than it was. I
actually kept fiddling with the syntax till I got it to
work, but I definitely like your way much better. So I
made that change.

Thanks,


Bruce Roberson
 
Top