Sorry if this seems long winded!
Is there a line in visual basic which can check a value of a cell after running a macro and if the value is what you want the cell to value will stop the macro running.
For the experts C3 contains the result of a calculation at the end of running the macro its an =Max of various calculations in the spreadsheet. Running the macro results in a change of value in C3. I know that the calculations that I'm doing will only result in the answer (C3) being 6 and cannot be smaller or larger if everything matches the criteria I'm looking for, so can I instruct the macro to run until C3=6 and then stop! and if c3 does not=6 run again and check the answer.
In old BASIC you could invoke the If "C3=6" Then Go to ..... Else Go to .........
Is there an equivalent command in visual basic?
_________________________