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
|