hello everybody. I'm looking for a macro that updates a sheet until a certain cell meets a value. The cell in question depends on many random parameters so it can become lengthy to manually refresh pressing f9 hundreds of times until it meets a value (let's say for example that this value is 1). The cell (let's say, for example, A1) in question is located in a specific sheet, so the macro should be only looking in the cell of that sheet, rather than all of them. Thank you in advance.