OK, so I've managed to use this example from the forums of using Application.OnTime to perform tasks at regular intervals. And this seem to stop and start the macro so I can manipulate data in between calculations.
However, does anyone know how I could perform calculations on offset cells on every OnTime event but starting from a defined cell? I can only get the example below to use ActiveCell, which is annoying as I'm activating other cells by manipulating their data which transposes the code below onto the wrong cells.
For example, I need to start at A1 calculate, and then calculate B1, and then C1.
This then transposes to the next row (starting A2, A3, A4) every n seconds.
Bookmarks