(Solved) – Copy cell from filtered range, where is only one row

(solved)-–-copy-cell-from-filtered-range,-where-is-only-one-row

I’m trying to copy data from column in filtered range. The number of filtered rows is always different. First row is header.

I’m using this

ThisWorkbook.Sheets(1).Range("N2:N" & ThisWorkbook.Sheets(1).Range("N" & ThisWorkbook.Sheets(1).Rows.Count).End(xlUp).Row).SpecialCells(xlCellTypeVisible).Copy

This works fine, when the number of filtered rows is bigger than 1. But when there’s only one filtered row (and it should be N2:N2), it will copy the whole used range.

Thanks for advice.

Leave a Reply

Your email address will not be published. Required fields are marked *