I am trying to copy some data from an Auto Filtered list to another sheet in a Macro.
This is the line of code I am using to get the data;
Set rngFilt = Application.Intersect(.AutoFilter.Range.Offset(1).SpecialCells(xlCellTypeVisible), .Range("C:H"))
It works with one problem. With the Offset to not include the tiltle row, I am picking up one extra blank row of data that I don't want.
How do I get just the visible filtered data without the titles?
This is the line of code I am using to get the data;
Set rngFilt = Application.Intersect(.AutoFilter.Range.Offset(1).SpecialCells(xlCellTypeVisible), .Range("C:H"))
It works with one problem. With the Offset to not include the tiltle row, I am picking up one extra blank row of data that I don't want.
How do I get just the visible filtered data without the titles?
