Remove Autofilter
 

I would like to turn off the auto filter in sheet3. I can use:

Sheet3.Cells.AutoFilter

to toggle it on and off. I want to make sure that it is off before I run my
code. Can anyone help me determine the autofilter status? And then if it is
on then turn it off.

Thanks
The Doctor

Remove Autofilter
 

On 22 Feb, 09:26, Dr. Schwartz
wrote:
I would like to turn off the auto filter in sheet3. I can use:

Sheet3.Cells.AutoFilter

to toggle it on and off. I want to make sure that it is off before I run my
code. Can anyone help me determine the autofilter status? And then if it is
on then turn it off.

Thanks
The Doctor

..AutoFilterMode =False

Remove Autofilter
 

Hi
As well as .AutoFiltermode = False you might also throw in

On Error Resume Next 'required if Advanced filter used
.ShowAllData
On Error GoTo 0

incase Advanced filter has been applied.

regards
Paul

On Feb 22, 9:39*am, "michael.beckinsale"
wrote:
On 22 Feb, 09:26, Dr. Schwartz
wrote:

I would like to turn off the auto filter in sheet3. I can use:

Sheet3.Cells.AutoFilter

to toggle it on and off. I want to make sure that it is off before I run my
code. Can anyone help me determine the autofilter status? And then if it is
on then turn it off.

Thanks
The Doctor

.AutoFilterMode =False

Remove Autofilter
 

Thank you Michael - simple yet perfect!

The Doctor

"michael.beckinsale" wrote:

On 22 Feb, 09:26, Dr. Schwartz
wrote:
I would like to turn off the auto filter in sheet3. I can use:

Sheet3.Cells.AutoFilter

to toggle it on and off. I want to make sure that it is off before I run my
code. Can anyone help me determine the autofilter status? And then if it is
on then turn it off.

Thanks
The Doctor

..AutoFilterMode =False