only want to copy cells that are not hidden from 1 worksheet to another
J JulieD Dec 8, 2004 #2 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
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