Hi, I have driven myself "loopy" over something quite basic:
"A1" is a variable integer that feeds into an equation that yields "b2" as the result. "B3" is the copied value of "b2" at the start, so "b3" = "b2". "B3" does not get refreshed if "B2" changes.
The VBA code I am trying to compile will cover:
A1 can only be between 0 and 1000.
reduce the value of "a1" by incremental steps of 1 until b2 <> b3, then print the last "a1" value in "a1" where "b3"= "b2"
every time i try this i get a plethora of errors or end up in an infinity loop
any help would be greatly appreciated.
many thanks
Bookmarks