Posted to microsoft.public.excel.programming

David

external usenet poster

Posts: 1,560

Find Autofilter Header range

I have code from this community to 'reset' the autofilter for each worksheet
where AutoFilterMode = true (Thanks Patrick Molloy)
I see that I need to specify the target range for the filter headers
In my workbook filter headers may be on row 1, row 2 , etc
Is there a way to determine for each worksheet where the filter headers are
located?
Thanks

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
Autofilter header row	Mister Cul-de-sac	Excel Discussion (Misc queries)	3	April 11th 10 04:46 PM
AutoFilter Selection to Change Page Header	Darrell Lankford	Excel Programming	0	April 29th 08 06:38 PM
Cells.find only reporting range in AutoFilter...	mark	Excel Programming	4	October 30th 07 03:29 PM
AutoFilter Header Row	bgetson	Excel Programming	6	August 18th 07 02:45 AM
Error proof way to find first blank Row after Autofilter Range	[email protected]	Excel Programming	6	July 1st 07 01:42 AM

All times are GMT +1. The time now is 07:44 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us