MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copy All Filtered Rows after Header


Posted by Marcie on February 20, 2001 2:07 PM

I am trying to write VBA code to select the range of all filtered rows that are produced as a result of an autofilter statement. I do not want to include the header row in the selection. How do I programatically code this? I cannot seem to get it to work.


Posted by David Hawley on February 21, 2001 12:34 AM

Hi Marcie

Try this

ActiveSheet.UsedRange.Offset(1, 0).SpecialCells _
(xlCellTypeVisible).Copy

DaveOzGrid Business Applications

Posted by Marcie on February 21, 2001 7:43 AM

Thank you David! This works great!

Marcie