ExcelBanter - copy only non hidden cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - copy only non hidden cells (https://www.excelbanter.com/excel-worksheet-functions/7633-copy-only-non-hidden-cells.html)

Podgy

copy only non hidden cells

only want to copy cells that are not hidden from 1 worksheet to another

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

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

All times are GMT +1. The time now is 05:20 PM.