Dynamic range copy.

I have been able to filter my data by date but now that the filter is done I need to copy that from one sheet to another. The problem is the range will be dynamic so I don’t know how to do it. I usually will just record a macro and look at it. but this just takes the actual range not the dynamic range.

thanks very much

If it was done using an Autofilter then

activesheet.Autofilter.Range.Copy _
Destination:=Worksheets("Sheet2").Range("A1")

Only the visible rows are copied.

--
Regards,
Tom Ogilvy


"sungen99" <[email protected]> wrote in
message news:[email protected]...
>
> I have been able to filter my data by date but now that the filter is
> done I need to copy that from one sheet to another. The problem is the
> range will be dynamic so I don't know how to do it. I usually will just
> record a macro and look at it. but this just takes the actual range not
> the dynamic range.
>
> thanks very much
>
>
> --
> sungen99
> ------------------------------------------------------------------------
> sungen99's Profile:
http://www.excelforum.com/member.php...fo&userid=9144
> View this thread: http://www.excelforum.com/showthread...hreadid=378066
>