If anyone still knows how to do this then can you please let me know.

However, i figured out that i can just use "R2C1:R35C1" instead

Cheers

Dave


--
David494
------------------------------------------------------------------------
David494's Profile: http://www.excelforum.com/member.php...o&userid=24482
View this thread: http://www.excelforum.com/showthread...hreadid=391226