Bernie,
If the cells were hidden as a result of filtering (Data Filter
Autofilter)
then ALT; (shortcut for GOTO Special Visible Cells only)
Ctrl C (Copy)
Ctrl V (Paste)
Hope it helps
Regards Mick Barry
--
mickbarry
------------------------------------------------------------------------
mickbarry's Profile:
http://www.excelforum.com/member.php...o&userid=31028
View this thread:
http://www.excelforum.com/showthread...hreadid=507181