Macro in Excel (VB) [Closed]

Report
Posts
1
Registration date
Saturday October 24, 2009
Status
Member
Last seen
October 25, 2009
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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.

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
797
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!