I have a workbook with numerous spreadsheets. In these spreadsheets are numerous cells that contain IF formulas which are either true or false depending on the current date. I want to differentiate from the cells that are true and the cells that are false. if the cell goes to true it will return a value from an Add-in anywhere between 0-100. if the cell goes to false it will not call the Add-in and go to 0. The code I have so far goes cell by cell and tests it. The problem is that the way it tests the cell is by checking if the cell is equal to -1 for true and equal to 0 for false. Sometimes the cell IF formulas will be true and also have a value of 0, and I can never get -1 value in a cell. Also I cannot use a value other than 0 for False because all of the cells whether they are true or false are used by other cells which produce totals. Therefore I cannot use a space or a - as the value of the cell when it is false. Here is the code that I use to check to see if the cell is true or not.
'MX-2
Dim Cell As Range
Sheets("MX-2").Select
For Each Cell In Range("B8:H39")
If Cell.Value = True Then
'code
End If
Next Cell
I have also attached a example of what i have.