Take Me to the Current Month

[denholmeo]

Hi all,

This is my first post and hope you all can help me. I'm usually able to find my answer from other posts but I've searched forum but I can't find an answer to what I need.

I have a workbook with multiple differently names sheets that might change later with months listed down column E. The months aren't listed one right after the other. (January in E3, February in E19, March in E35, etc.) Also, the months are returned by formula so in Cell E3 I have 1/1/16, E19 is =E3+31, E35 is =E19+31, etc.) I would like a macro that I can put on every worksheet so that when I activate it, it searches for the current month in Column E and then takes me there. I would like to be able to keep the formulas but if I need to change them all to actual dates, I can do that too.

Thanks so much for your help!

[xladept]

Hi denholmeo,

Welcome to the Forum!

Try:

Please Login or Register  to view this content.

[denholmeo]

Wow you all really are fast. Thanks so much for this, xladept!

[xladept]

You're welcome

[xladept]

Thanks for the rep!