Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
autofilter
hi,
I am getting the following error message: runtime error 1004 unable to get the autofilter property of the range class as a result of the following code: Sheets("NewBKInput").Visible = True Sheets("NewBKInput").Activate Sheets("NewBKInput").Select 'sort the month column before selecting the oldest month If Selection.AutoFilter = True Then Selection.AutoFilter 'turn off autofilter option End If How can I fix this? I do not understand why the following code (which appears above the code above) works fine: Sheets("Input1").Visible = True Sheets("Input1").Activate Sheets("Input1").Select 'sort the month column before selecting the oldest month If Selection.AutoFilter = True Then Selection.AutoFilter 'turn off autofilter option End If Columns("A:O").Select Thanks in advance, geebee |
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) | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) |