ExcelBanter - Skip hidden rows while copying down in excel?

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Skip hidden rows while copying down in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/110813-skip-hidden-rows-while-copying-down-excel.html)

DRSTCSPM

Skip hidden rows while copying down in excel?

I have done this but can not remember how. How do I skip hidden rows while
copying down in excel?

Dave F

Skip hidden rows while copying down in excel?

Edit--Go To--Special--Visible Cells Only

Dave
--
Brevity is the soul of wit.

"DRSTCSPM" wrote:

I have done this but can not remember how. How do I skip hidden rows while
copying down in excel?

DRSTCSPM

Skip hidden rows while copying down in excel?

Yup that's it. Thanks

"Dave F" wrote:

Edit--Go To--Special--Visible Cells Only

Dave
--
Brevity is the soul of wit.

"DRSTCSPM" wrote:

I have done this but can not remember how. How do I skip hidden rows while
copying down in excel?

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