If you start your data|filter|advanced filter on the "receiving" worksheet, it
should work ok.

Gary''s Student wrote:

I don't know if its a bug or just a limitation. I tried to manually run
Advanced Filter with the Recorder either turned on or off. Manually,
naturally, we are always on the sheet that the filter is using. When I tried
to save to a destination that was on another sheet, Excel generated an error
message saying I can't do it.
--
Gary''s Student - gsnu2007

" wrote:

Thanks for the reply.
That actually brings up a separate problem/bug documented by Microsoft. The
data is actually filtered to another worksheet which must be activated.

Sorry about leaving that out but I didn't think it was an issue since I was
handling another bug.

Is this particular bug documented somewhere?

Steve


"Gary''s Student" wrote in message
...
Go there first:

Sub Macro2()
Sheets("a a").Activate
Range("A1:C10").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range( _
"K5"), Unique:=True
End Sub

--
Gary''s Student - gsnu200746


" wrote:

Doing an advanced filter on a worksheet with a space in the worksheet
name
causes it to crash even if using a variable such as
ws.range(somerange).advancedfilter.

Anyone know what causes it or work around?

Thanks







--

Dave Peterson