ExcelBanter - Copying data without hidden rows.

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

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

- - Copying data without hidden rows. (https://www.excelbanter.com/excel-worksheet-functions/23821-copying-data-without-hidden-rows.html)

Cube Farmer

Copying data without hidden rows.

I am trying to copy data and not include the rows and columnc that I have
hidden.
I know there has to be an easy way but for some reason I am playing stupid
this morning.
Thanks in advance.

Duke Carey

After selecting the range, press the F5 key, click on the Special button, and
check Visible Cells Only

"Cube Farmer" wrote:

I am trying to copy data and not include the rows and columnc that I have
hidden.
I know there has to be an easy way but for some reason I am playing stupid
this morning.
Thanks in advance.

Max

After selecting the range, press F5 Special Visible cells only OK.
Then do the copy paste, and only the visible cells get copied/pasted
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Cube Farmer" <Cube wrote in message
...
I am trying to copy data and not include the rows and columnc that I have
hidden.
I know there has to be an easy way but for some reason I am playing stupid
this morning.
Thanks in advance.

All times are GMT +1. The time now is 03:28 AM.