Here is something directly from the help files.

Use the Add method to create a name and add it to the collection.The
following example creates a new name that refers to cells A1:C20 on the
worksheet named "Sheet1."

Names.Add Name:="test", RefersTo:="=sheet1!$a$1:$c$20"

I hope that is what you need.


--
jdawson
------------------------------------------------------------------------
jdawson's Profile: http://www.excelforum.com/member.php...o&userid=32198
View this thread: http://www.excelforum.com/showthread...hreadid=552410