Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 -- sungen99 ------------------------------------------------------------------------ sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144 View this thread: http://www.excelforum.com/showthread...hreadid=378066 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic range copy.
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range | New Users to Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
dynamic name range in VBA | Excel Programming | |||
dynamic sheet copy | Excel Programming | |||
Excel 2000 VBA - Set Print Range in dynamic range | Excel Programming |