Hi,
Am having an issue where i want to run a macro but am unable to run it due to my code referencing it to the active worksheet.
The case is:
Open workbook is
Book 1
MACRO FINETUNE (This is where the macro code is located)
-Having a code inside this MACRO FINETUNE workbook named inside a worksheet named "FILTERING CRITERIA"
Having the error subscript out of range.
This is the code snippet where this error happen.
Code
Cells(4, 3).AutoFilter Field:=3, _
Criteria1:=Array(Split(Worksheets("FILTERING CRITERIA").Range("A2").Value, ",")), Operator:=xlFilterValues
Am running this code using shorcut key from Book1.
How do i reference the code of the macro worksheet?