Select data in filtered list

[Stephen Rainey]

Hi,
I have a filtered list that I wish to copy using VBA. Each time the
filter is applied, the size of the list may vary.
It is simple to cut&paste, however my objective is to write a macro to
automate this task as it is repeated hundred/thousands of times.

So, can someone please suggest how to "select" the contents of the filtered
list in a macro ?

 

[Guest]

Try Debra's page at:
http://www.contextures.com/xlautofilter03.html
Scroll down to "Copy Filtered Rows" for the Sub CopyFilter() by Tom Ogilvy

 

[Jim May]

I use this to Send the Current Auto-Filtered Data to a new sheet:


Sub DumpAutoFilterToNewSheet()
Dim ws As Worksheet
Dim ws1 As Worksheet
Set ws = ActiveSheet
Set ws1 = Worksheets.Add
ws.Activate
ws.AutoFilter.Range.Copy _
Destination:=ws1.Cells(1, 1)
End Sub

Hope this Helps,