"Goto" function or macro

[jason.hampton]

All,

I would like to ask if there is a way to "goto" today's date in the attached worksheet. I have selected row 4 and added simply conditional formatting for "This Week". My goal would be to have a hyperlink or macro to take you back today's date from anywhere in the document.

[Hood]

Needs some work, but this might work as a macro....

Please Login or Register  to view this content.

[jason.hampton]

Hood,

Thank you. A work colleague just hooked me up; I tweaked it and added some features to it. Then I pasted an image onto the top of the page and assigned this macro to it. It works great! I have tried it on several different worksheets. If I am not on the correct sheet, the error message pops up "Date Not Found. Are you on the correct worksheet?".

Please Login or Register  to view this content.

[Hood]

Hell Jason,

Just add Sheet2.Select to the code like this...

Please Login or Register  to view this content.

[jason.hampton]

Hood,

I really appreciate the feedback! Can you explain what function does "Sheet2.Select" perform? I have never utilized this syntax.

[jason.hampton]

I tried that syntax in my workbook with many worksheets. It directs me to my "contacts" worksheet, and the error message pops up.

[Winon]

Hello jason.hampton,

Maybe something as per the attached sample Workbook?

Regards.

[JOHN H. DAVIS]

FWIW:

Please Login or Register  to view this content.

[Hood]

Sheet2.Select activates Sheet2. It looks like Sheet2 in your current workbook is named "contacts".
You could use Sheet("Jan - June 2015").Select


I like John's Code....
Maybe this, I don't know...

Please Login or Register  to view this content.

[jason.hampton]

Hood,

I saved your test as an .xlsm file. Then copied your syntax and button into my larger workbook. It seems to work flawlessly. I've added to both you and John's reputation.