vba equivalents of set.name and define.name
I'm converting an old xlm file to vba. What are the vba
equivalents of set.name and define.name? Thanks. |
vba equivalents of set.name and define.name
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. |
vba equivalents of set.name and define.name
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. |
All times are GMT +1. The time now is 02:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com