Name field value
Hi,
Hoe can I set a value from vb for a name I defined (InsertNameDefine). ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Name field value
If it is already defined
assume the name is MyNum ThisWorkbook.Names("MyNum").RefersTo = "=10" if by value you mean you want it to be associated with a range of cells Worksheets("Sheet4").Range("B9:C23").Name = "MyRange" msgbox Range("MyRange").Address(external:=True) -- Regards, Tom Ogilvy "efi" wrote in message ... Hi, Hoe can I set a value from vb for a name I defined (InsertNameDefine). ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Name field value
THANKS!!!!!!
------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
All times are GMT +1. The time now is 05:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com