Hi, Hoe can I set a value from vb for a name I defined (Insert>Name>Define).
T Tom Ogilvy Oct 30, 2003 #2 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)
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)
