Bob,

Thanks for your help very much.

I tried the following, starting my range at F1, and continuing down th
F Col:

ActiveWorkbook.Names.Add Name:="TEMPLE", RefersTo:= _
"$F$1:OFFSET($F$1,,,COUNTA($F:$F))"

It did not work.
Chuckles12

--
Chuckles12
-----------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494
View this thread: http://www.excelforum.com/showthread.php?threadid=26589