Posted to microsoft.public.excel.programming

John[_140_] John[_140_] is offline

external usenet poster

Posts: 57

Advanced data filtering on different sheet

When using advanced filtering with copy to another location, can you copy to
a different sheet? I have a sub procedure that does just that and it fails
occassionally with the following error messages:

You can only copy filtered data to the active sheet.
or
AdvancedFilter method of range class failed.

I don't understand why it works soometimes and fails other times. Is there a
workaround?

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
Advanced Filtering and Data Entry	Scott Halper	Excel Programming	2	July 9th 08 11:00 PM
Advanced Filtering on an inactive sheet	Spencer	Excel Programming	2	April 23rd 07 01:10 AM
advanced filtering	jiwolf	Excel Worksheet Functions	2	October 19th 05 09:43 PM
Advanced Filtering	Tony	Excel Worksheet Functions	3	April 29th 05 11:48 AM
advanced filtering	spence[_3_]	Excel Programming	2	January 21st 04 02:03 AM

All times are GMT +1. The time now is 07:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us