Basically i'm not much of a programmer, but can do the basics on Excel. I've just been writing a nice little programme on Excel, but need some help writing a macro on there.
All I want to do is to navigate from the 'home' sheet tab to another sheet tab called 'OBT'.
In the OBT sheet I have a list of dates starting at cell D11 and going down to D133 at the moment, but this will be a list which will expand frequently as I add more data to the list.
I want the macro to navigate to the next blank cell in the list when I navigate to the sheet, in order to not have to scroll all the way down the list every time I go to that page.
Ive been fiddling around and have tried using a counter to count the number of items in the list, then using the 'Offset' function to offset the number of cells from the top of the list, but can't seem to crack it... it doesnt do the 'offset-ing'.