I'm trying to test if a cell range that has a formula in it shows an error. I've tried this code:
i'm getting a type mismatch debug, even though the cell range shows to have an 'Error 2023'
is there a way to test if a cell has an error in it in vba?
Code:
If BudSht.Range("CheckValue") = Error Then Exit Sub
i'm getting a type mismatch debug, even though the cell range shows to have an 'Error 2023'
is there a way to test if a cell has an error in it in vba?