Macro in Excel (VB)

Closed
pmycrth Posts 1 Registration date Saturday October 24, 2009 Status Member Last seen October 25, 2009 - Oct 25, 2009 at 06:22 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 25, 2009 at 09:00 PM
Hello,

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'.

Any help would be much appreciated. Thanks.
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 25, 2009 at 09:00 PM
select D11 a nd hit "end" key ( normally in the middle section top) and hit downwarad arrow (in the middle section of the keyboard bottom).. this will take to the last cell. and you can step one more.

this does not require a macro as it is trivial action.
0