Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
remove autofilter from some columns | Excel Programming | |||
Remove Autofilter | Excel Programming |