Posted to microsoft.public.excel.programming

Nena[_2_]

external usenet poster

Posts: 20

advancedfilter action

My goal is to autofilter the data in Column C Sheet 1 and have the
results placed in Column A Sheet 2 but it is not working, what am I
doing wrong?

Sheet1("C:C").AdvancedFilter
Action:=xlFilterCopy,Sheet1:=Range("C:C"),
CopyToRange:= Sheet2.Range(_"A6"),Unique:=True

Thanks in advance.

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
Excell copy action pauses for 15 second for the smallest action	Meekal	Excel Discussion (Misc queries)	1	January 28th 10 04:30 PM
AdvancedFilter	dannibrook	Excel Programming	4	April 25th 06 11:19 AM
AdvancedFilter with VBA	newToExcel	Excel Programming	2	September 30th 05 05:20 PM
AdvancedFilter in VB	loopy[_6_]	Excel Programming	1	June 22nd 05 03:24 PM

All times are GMT +1. The time now is 05:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us