copy only from a cell with data in it
 

ok last time to move this up to see if anyone can help.

thanks to everyone who looked.
jo

--
Joe
-----------------------------------------------------------------------
JoeH's Profile: http://www.excelforum.com/member.php...fo&userid=1413
View this thread: http://www.excelforum.com/showthread.php?threadid=26267