Hi

select the range that contains the cells you want to copy
choose edit / go to and click on the Special button
choose visible cells only
now copy & paste as usual.

Cheers
JulieD

"Podgy" wrote in message
...
only want to copy cells that are not hidden from 1 worksheet to another