Here is my question:
The new workbook was saved as xlsx in My Documents. So far so good.
But when I tried to filter a single column, the filter was not available.
But if I wanted to filter the entire sheet, it did allow me.
I have a macro that bombs out here
Code: Select all
Selection.AutoFilter
What do I need to do to have the filter available?
Here is the entire macro code:
Code: Select all
ActiveWindow.LargeScroll ToRight:=3
Columns("BI:BI").Select
Selection.AutoFilter
ActiveSheet.Range("$BI$1:$BI$100000").AutoFilter Field:=1, Criteria1:="=N", _
Operator:=xlOr, Criteria2:="="
Rows("2:100000").Select
Range("BF2").Activate
Selection.Delete Shift:=xlUp
Selection.AutoFilter
Application.Run "Personal.xlsb!UHCMS_HOSPICE"
Cells.Select
Selection.ColumnWidth = 8.57
Cells.EntireColumn.AutoFit
Range("C12").Select
Application.Run "Personal.xlsb!ADD_OUTCOME_COLUMN"