Filtered Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I programatically identify the range of rows displayed by filtered
data? I programatically provide the filter value, and then need to copy the
results to another sheet.

Thanks.
 
Marvin, Use this code change Column "A" for your filtered column.
Range("A2",Range("A2").End(xlDown)).EntireRow.SpecialCells(xlCellTypeVisible).Copy Worksheets("YourSheet2").Range("A1")
 
Back
Top