ExcelBanter - How can I copy and paste only on the unhiden cells?

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

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

- - How can I copy and paste only on the unhiden cells? (https://www.excelbanter.com/excel-worksheet-functions/207457-how-can-i-copy-paste-only-unhiden-cells.html)

meili

How can I copy and paste only on the unhiden cells?

How can I copy and paste only on the unhiden cells?

Peo Sjoblom

How can I copy and paste only on the unhiden cells?

Select the cells, press F5, select special and visible cells only, click OK,
then copy

--

Regards,

Peo Sjoblom

"meili" wrote in message
...
How can I copy and paste only on the unhiden cells?

Energy

How can I copy and paste only on the unhiden cells?

think the "values only paste" ignores hidden cells.......

"meili" wrote:

How can I copy and paste only on the unhiden cells?

meili

How can I copy and paste only on the unhiden cells?

thanks a lot. it works out. :-)

"Peo Sjoblom" wrote:

Select the cells, press F5, select special and visible cells only, click OK,
then copy

--

Regards,

Peo Sjoblom

"meili" wrote in message
...
How can I copy and paste only on the unhiden cells?

All times are GMT +1. The time now is 11:14 PM.