(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 *