Autofilter on hidden sheet

Posted to microsoft.public.excel.programming

JLR-Mart

external usenet poster

Posts: 24

Autofilter on hidden sheet

Does anyone know if it is possible to use autofilter on a hidden worksheet. I
know that as a workaround I can make it visible, do the do, and then make it
hidden again, but out of curiosity I wondered whether this is some sort of
restriction??

We've tried several methods without any success.

Any help greatly appreciated

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
Rows hidden by Autofilter vs hidden by changing the Hidden property	LEO@KCC	Excel Programming	4	September 11th 07 10:14 AM
AutoFilter & Hidden Rows	John[_88_]	Excel Programming	2	July 22nd 04 03:28 AM
Saving hidden data with a worksheet (preferably without using a hidden sheet)	Dick Kusleika[_3_]	Excel Programming	2	January 21st 04 04:39 PM
Is it possible to tell if a cell is hidden by 'Autofilter'	Tom Ogilvy	Excel Programming	2	September 6th 03 07:57 PM
Is it possible to tell if a cell is hidden by 'Autofilter'	Dave Peterson[_3_]	Excel Programming	0	September 1st 03 04:29 PM

All times are GMT +1. The time now is 09:11 PM.

Menu

About Us