Here is one way

Range("A1").CurrentRegion.Name = "myFirstRange"


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Richard m" wrote
in message ...

I am using several tables with one of them called Database. When I add
items to the other ones how do I create or redefine the range for a
range name using VBA?


--
Richard m


------------------------------------------------------------------------
Richard m's Profile:
http://www.excelforum.com/member.php...fo&userid=2601
View this thread: http://www.excelforum.com/showthread...hreadid=519848