VBA: goto cell in column A:A that contains date of sunday for curent week.

[mike760534211]

I have looked everywhere and unable to locate my answer. is is possible to write some VBA code that would, at the click of a button, go to the cell in Column A that contains the date for Sunday of the current week.

Column A contains dates that fall on every Sunday from start of 2014 - 12/9/2029.

example:
Current week is 11/23/2014-11/29/2014
Today is 11/25/2014
Current Weeks Sunday date is 11/23/2014

then when opening the book I could potentially be in cell A1 but click a button and it takes me to cell A52 which actually contains 11/23/2014 which is the current weeks Sunday date.

Apologies in advance if i am unclear or confusing.

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[pjwhitfield]

Please Login or Register  to view this content.

if you want it to open on that cell whenever you open the book then put the code into the Workbook_Open event

[mike760534211]

That worked great thank you.

[TMS]

That worked great thank you.

What did? You had two very different solutions. And I think the second will select the current date.

Regards, TMS

[mike760534211]

What did? You had two very different solutions. And I think the second will select the current date.

Regards, TMS

this one that you supplied:

Please Login or Register  to view this content.

[mike760534211]

Please Login or Register  to view this content.

if you want it to open on that cell whenever you open the book then put the code into the Workbook_Open event

If they cant click a button, then they can just scroll. lol
but the code works great. i just tested it but it doesn't have to go to the date upon open as their is a graph at the top that should always be displayed first.

[TMS]

Ah, OK. Just checked the other routine. It goes to the day after today.

If you did want a routine to go to today's date, you could modify it to:

Please Login or Register  to view this content.

Or, modify my code to:

Please Login or Register  to view this content.

Regards, TMS