I am using AutoFilter to filter about 60 rows of data to about 11 (that are not blank). The code is below.
sht.AutoFilter.Range = "K1:N1"
The rows filter fine. Now, I want to copy columns K through N for these filtered rows to another range in the spreadsheet (P through S). How do I copy just these filtered rows? I tried looping through rows and using GetRowHeight figuring that they are hidden and their row height would be 0 but they are not.