Macro to "find" the next empty cell in a range
Thanks for help writing the macro.
Assumption: No price values are currently entered in the price cell
range (S&P 500). Range B56:AF133 cells are all empty.
Each time the macro is run the next empty cell in Range B56:AF133 will
become the active cell.
Desired Outcome: Each time I run the macro (ctl-f) it locates the next empty
cell in the range as the active cell. A price value can then be entered in
the found cell, or another forward cell in the range.
Below is a script of how the macro should function.
Action: Run macro.
Outcome: Cursor should land in cell B56 (since no cell in range are
populated with a value).
Action: Enter a value in cell E56 (Jan. 4).
Action: Run macro.
Outcome: Cursor should land in cell F56 (since it is the next empty
cell in range).
Action: Enter a value in cell L56 (Jan. 11).
Action: Run macro.
Outcome: Cursor should land in cell M56 (since it is the next empty
cell in range).
Thank-you
|