This is my current formula (the calculation works fine):
But I want that if Q33 has no value (but there is a formula in it), then do nothing. What do I need to change in my code to achieve that?
You can use this udf
Function hasfrmla(x As Range) As Boolean
If x.hasformula Then hasfrmla = True
and the formula