Macro to move cursor to column containing current date at worksheet activation

**Snoddas** · 09-03-2013, 04:18 AM

Hi all geniuses!

I have a worksheet that lists dates on one row and across multiple columns (Column A to AGS on row 2) as per my example file attached.
I want to create a macro that upon worksheet activation moves the cursor to the cell on row 2 that contains today's date.

I found this macro that works if i had dates listed in rows on a single column instead of the other way around like i have:

Please Login or Register  to view this content.

I tried to modify it to work with my setup but couldn't get it to work.

I also would like the scrolling to work in a way so that when the cursor moves to the cell with the current date, it doesn't make that cell the farthest to the right but instead the first visible cell to the left.

Thank you all in advance!

**NickyC** · 09-03-2013, 04:39 AM

Hi try this macro

you should also edit your own post and put your code in code marks, or a moderator will ping you!

Please Login or Register  to view this content.

**Snoddas** · 09-03-2013, 04:45 AM

Originally Posted by NickyC

Hi try this macro

you should also edit your own post and put your code in code marks, or a moderator will ping you!

Please Login or Register  to view this content.

First, thank you for that posting info, i have edited my post accordingly.

Second, thank you for that macro! It works fine. However, it does not scroll so that the marked current date is the left-most date but instead it centers the current date. Any suggestion on changes in the macro to make the marked cell the left most cell?

Thank you

**NickyC** · 09-03-2013, 04:55 AM

Hi try this variation

Please Login or Register  to view this content.

**Snoddas** · 09-03-2013, 05:40 AM

Originally Posted by NickyC

Hi try this variation

Please Login or Register  to view this content.

That did it Nicky! I am very grateful for all your help, thank you so much!

Reputation added

Macro to move cursor to column containing current date at worksheet activation

LinkBack

Thread Tools

Rate This Thread

Display

Macro to move cursor to column containing current date at worksheet activation

Re: Macro to move cursor to column containing current date at worksheet activation

Re: Macro to move cursor to column containing current date at worksheet activation

Re: Macro to move cursor to column containing current date at worksheet activation

Re: Macro to move cursor to column containing current date at worksheet activation

Thread Information

Users Browsing this Thread

Similar Threads

Cursor To be positioned on a cell containing the current date

Move cursor to specified cell on next worksheet

How do you set cursor position at current date in macro?

Cursor auto move from one cell to another-How can I have my cursor automatically move

Cursor wil not move left in worksheet

Bookmarks

Bookmarks

Posting Permissions