rlpowers45
New Member
- Joined
- Oct 4, 2022
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
I created a macro to run from buttons over a set of columns to filter for Xs in the column as below
Sub SetFilter(Col)
Call Unfilter
Worksheets("Manuals QC").Range("A3").AutoFilter field:=Col, Criteria1:="X"
End Sub
(Note: Unfilter() clears all the filters)
When I originally assigned the macro to the button I put quotes around it and include the column number, e.g., "Sheet6.SetFilter(7)"
This worked great but has suddenly stopped working with an Excel error message
My work around is to create multiple subs to assign to each button but it's irritating to working code suddenly stop working. Am I missing something? Did a new Excel release occur that changed this?
Thanks in advance for advice and consolation.
Sub SetFilter(Col)
Call Unfilter
Worksheets("Manuals QC").Range("A3").AutoFilter field:=Col, Criteria1:="X"
End Sub
(Note: Unfilter() clears all the filters)
When I originally assigned the macro to the button I put quotes around it and include the column number, e.g., "Sheet6.SetFilter(7)"
This worked great but has suddenly stopped working with an Excel error message
My work around is to create multiple subs to assign to each button but it's irritating to working code suddenly stop working. Am I missing something? Did a new Excel release occur that changed this?
Thanks in advance for advice and consolation.