I am very new to VBA. Here us my problem.
I have four cells that include large random numbers. When those numbers have certain characteristics and relate appropriately to each other, another cell acknowledges that fact by displaying the number 1000.
Say cell B1 is the cell that will display the number 1000.
How can I write the code so that the spreadsheet will keep re-calculating until 1000 appears in B1 and then stop? I want a code that references only B1 and not the cells with random numbers. Is there a way to do this without VBA?
Bookmarks