Is there a way to test if cell contains a value or a formula? I assume “=IsFormula()” but apparently I’m missing something. I’d like to either run this directly from VBA, something like either one of the following:
1. If B100 is formula (not a value) then do THIS otherwise do THAT.
2. If B100 is value (not a formula) then do THIS otherwise do THAT.
OR by placing the function in an adjacent cell to return YES or NO.
Thanks,
Steve
1. If B100 is formula (not a value) then do THIS otherwise do THAT.
2. If B100 is value (not a formula) then do THIS otherwise do THAT.
OR by placing the function in an adjacent cell to return YES or NO.
Thanks,
Steve