Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name field value
THANKS!!!!!!
------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove a Calculated Field from the Pivot Table field list | Excel Discussion (Misc queries) | |||
How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
Unable to change field settings in calculated field in a pivot tab | Excel Discussion (Misc queries) | |||
Linked date field in worksheet defaults a blank field as 1/0/1900 | Excel Worksheet Functions | |||
create formula. 1 field constant and another field varies by inpu. | Setting up and Configuration of Excel |