Named Reference

[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

 

[Ron Coderre]

It seems to me that the first method creates a named range that is
essentially meaningless to the user and is only used for VBA processing.
Additionally, if you don't write code to delete the named range it will just
sit there in the workbook waiting for somebody to ask what it means.

The second alternative is a cleaner way to declare the range variable
without having it intrude upon the user-facing part of the workbook.

Just my opinion....Your mileage may vary.

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[Dave]

Ron, that's a good explanation. I did have a vague idea that the 2nd
way was better (the code seemed "neater") but couldn't quite say why it
was so.

Thanks a lot

DaveU