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 ?

[Max]

Try Debra's page at:
http://www.contextures.com/xlautofilter03.html
Scroll down to "Copy Filtered Rows" for the Sub CopyFilter() by Tom Ogilvy
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Stephen Rainey" wrote:
> 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 ?
>
>
>

[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,


"Stephen Rainey" <[email protected]> wrote in message
news:Op#[email protected]:

> 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 ?