Hi Tes

select the range you want to copy, choose edit / goto / special - choose
visible cells only
then copy
then paste as normal

cheers
JulieD

"Tes" wrote in message
...