vbahelper123
New Member
- Joined
- Aug 20, 2016
- Messages
- 3
Hello!
Is there a way to calculate a sheet until a cell is ≠ False in VB?
I have cells Q92:V92 with IF statements
"=IF(AND($O$101>98%,$O$101<99%),$B$99,FALSE"
I just want the sheet to continue to calculate until one of those cells becomes true and displays a number instead of constantly hitting the calculate now button.
Is there a way to calculate a sheet until a cell is ≠ False in VB?
I have cells Q92:V92 with IF statements
"=IF(AND($O$101>98%,$O$101<99%),$B$99,FALSE"
I just want the sheet to continue to calculate until one of those cells becomes true and displays a number instead of constantly hitting the calculate now button.