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