Thread: relative destination for advance filter results
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
davechev davechev is offline
external usenet poster
  
Posts: 1
Default 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 QuoteReply With Quote