Calculate Sheet Until

[vbahelper123]

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.

 

[sheetspread]

You can use the specialcells method to distinguish between logical and number

 

[vbahelper123]

I did not know about this function! Thank you! I keep getting a compile error #dontknowwhatimdoing

Sub SpecialCells()
Range(Range(“Q92:V92”).SpecialCells(xlNumbers).Calculate
End Sub

 

[sheetspread]

Try

Sub Spectest()
Range("Q92:V92").SpecialCells(xlCellTypeFormulas, 1).Calculate
End Sub

 

[vbahelper123]

Ahhh no, still doesnt work. Maybe I need a different approach.

 

[sheetspread]

You can use ctrl-h replace = with = on the worksheet, or .formula = .formula in VBA to recalculate formulas appearing as strings