D
Dave
Hi,
Can someone tell me what the pros and cons are (if any) of these 2 ways
of naming a range.
ActiveWorkbook.Names.Add NAME:="HOME", RefersTo:=ActiveCell
Range("HOME").Select
or
Dim HOME As Range
Set HOME = ActiveCell
HOME.Select
Thanks,
DaveU
Can someone tell me what the pros and cons are (if any) of these 2 ways
of naming a range.
ActiveWorkbook.Names.Add NAME:="HOME", RefersTo:=ActiveCell
Range("HOME").Select
or
Dim HOME As Range
Set HOME = ActiveCell
HOME.Select
Thanks,
DaveU