How can I get all row number of visible cell after filtering? I need to have number of each visible row to copy some cells. For example I have 15 rows. After filtering there are only Row 2nd and Row 10th visible. How find Cell (10,2)
and (2,2)
?
For example there are 15 rows in sheet1.
After filtering only row 2
and row 10
are visible. I want to copy cell (10,2)
and cell(2,2)
. But I could not.
sheet2.Cells(2, w) = sheet1.Cells(k, 1)
It put k=1 and copy from the first row. It should k=2 and k=10.