I am confused. If you add a name via VBA you only need to do it once, not
for every cell in the column.

--

HTH

RP

"Chuckles123" wrote in message
...

Bob,

Thanks for your help very much.

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

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

It did not work.
Chuckles123


--
Chuckles123
------------------------------------------------------------------------
Chuckles123's Profile:
http://www.excelforum.com/member.php...o&userid=14948
View this thread: http://www.excelforum.com/showthread...hreadid=265895