I'm converting an old xlm file to vba. What are the vba
equivalents of set.name and define.name? Thanks.

These refer to Defined Names within Excel, which in the product is created
via menu

InsertNameDefine ...

and provide the name, and the RefersTo value.

In VBA that can be done by building the name, and then assigning a value to
the range

ActiveWorkbook.Names.Add Name:="Bob", RefersTo:=Range("A1")
Range("Bob").Value = 123

A simpler way of defing the name is from a range

Range("A1").Name = "Bob"

and set the value as before

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"John Smith" wrote in message
...
I'm converting an old xlm file to vba. What are the vba
equivalents of set.name and define.name? Thanks.

This help file has a section on VB equivalents of XL4 functions.

http://www.microsoft.com/downloads/i...splayLang%3den

--
Jim
"John Smith" wrote in message
...
I'm converting an old xlm file to vba. What are the vba
equivalents of set.name and define.name? Thanks.