Hi I have an interesting one for you.

If I have cells A1:A1000, G1:G1000 & K1:K1000

is it possible to create a named range for each of the 3000 cells i
code and call them all sequentially 1-3000

Thanks if you can help. This will save me so much time!

Ro

--
robhargreave
-----------------------------------------------------------------------
robhargreaves's Profile: http://www.excelforum.com/member.php...fo&userid=2551
View this thread: http://www.excelforum.com/showthread.php?threadid=39031