Named Reference

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 17 Dec 2005 02:09 GMT

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

Reply to this Message

Ron Coderre - 17 Dec 2005 04:33 GMT

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

> Hi,
>
[quoted text clipped - 13 lines]
>
> DaveU

Reply to this Message

Dave - 17 Dec 2005 08:20 GMT

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

Reply to this Message