Sheet navigation macro

[John_Whin]

Hockey spreadsheet, in column A I've got the game number and enter scoring info beginning column B. What I want to do is set up macro that navigates to first open cell and the takes the number in the last non empty cell, adds 1 then moves cursor right to a specific column.

So on this sheet I've assigned a macro to A1. I want it to move cursor down column A to the last non empty cell (A83) take that value and add one to it and put that result in A84 then move cursor to B84 for input. I'll copy/paste data into the next row(s). The next game I want it to do same thing.

Thanks

 

[mikerickson]

The syntax in post #7 should return the range object that is the first blank cell in column I.
If you want the cursor to go to that cell, then .Select the cell.

Note that "blank" can have different, frustrating meanings. A cell that hold a formula which returns the value of "" is not considered blank by Excel.


With your background, VBA is trivial (remember old BASIC ? ) but those languages you listed are not object oriented languages, Excel VBA is object oriented.

 

[John_Whin]

Yeah, I'm looking at a learn VBA course from 2012 online and know I'm close, just have to get back in that mental mode. Figure I've got a simple mental block (sand grain) to overcome then I'll be good. As you notice all my program languages are pre windows.