Posted to microsoft.public.excel.misc

davechev

external usenet poster

Posts: 1

relative destination for advance filter results

I have the following macro to perform a filter. I would like to substitute
the cell
address contained in cell "G1" (which changes) for the destination address,
which
is now "G3".

Range("g3:k3500").Select
Selection.ClearContents
Range("G1").Select
Sheets("CVO data").Range("H1:L3000").AdvancedFilter
Action:=xlFilterCopy, _
CriteriaRange:=Range("I1:I2"), CopyToRange:=Range("G3"), Unique:=True

Can this be done?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
advance filter	Alberto Ast[_2_]	Excel Discussion (Misc queries)	6	October 10th 09 01:47 AM
Advance Filter	Alberto Ast[_2_]	Excel Worksheet Functions	0	March 5th 09 12:44 AM
Advance Filter	JRey	Excel Discussion (Misc queries)	2	November 14th 08 07:01 PM
Advance Filter	Obi-Wan Kenobi	Excel Discussion (Misc queries)	3	March 22nd 06 09:47 PM
about advance filter	Max	New Users to Excel	1	December 30th 04 04:59 AM

All times are GMT +1. The time now is 12:54 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us