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/