I get the above error message, this is my code:
Sub Filters()
Dim WorkWks As Worksheet
Dim rngA As Range
Set WorkWks = Worksheets("WorkInProcess")
Set rngA = WorkWks.Range("Dates")
The error is in the Set rngA line
The named range is =OFFSET(WorkInProgress!$T$1,0,0,COUNTA(WorkInProcess!$T:$T),1)
The error only occurs when Column has 0-1 Rows, I assume when rows = 0 is due to #Ref error
How can I check if there is an error in the range and can exit the sub?
Thanks
Sub Filters()
Dim WorkWks As Worksheet
Dim rngA As Range
Set WorkWks = Worksheets("WorkInProcess")
Set rngA = WorkWks.Range("Dates")
The error is in the Set rngA line
The named range is =OFFSET(WorkInProgress!$T$1,0,0,COUNTA(WorkInProcess!$T:$T),1)
The error only occurs when Column has 0-1 Rows, I assume when rows = 0 is due to #Ref error
How can I check if there is an error in the range and can exit the sub?
Thanks