Go to today's date column

**greasybob** · 01-22-2007, 04:28 PM

HI,
I have columns labeled with various dates.
How can I have excel go to the column with todays date when the sheet is opened?
Thanks,
Bobby

**VBA Noob** · 01-22-2007, 04:41 PM

Hi,

Enter this code in the sheet with the dates

Please Login or Register  to view this content.

Assumes Date in Column A

VBA Noob

**greasybob** · 01-22-2007, 05:02 PM

Thanks for the quick reply.
I'm really not very good at this VBA thing yet (very interested though).
O.K. so I put the code into the sheet, saved and re-opened. But I couln't get it to work.
My dates are at the top of the columns, not in rows. So I'm thinking the code as written may be for the dates being in rows?
Thanks

**VBA Noob** · 01-22-2007, 05:06 PM

Hi,

Try the below. Right click the sheet tab with the dates then select View code
Paste the below into VB and close.

Select a different sheet. then reselect the sheet with the dates.

Assumes dates are in Row 1 this time

Please Login or Register  to view this content.

VBA Noob

**VBA Noob** · 01-22-2007, 05:09 PM

Example attached

VBA Noob

**greasybob** · 01-22-2007, 05:15 PM

Still no go.
Is this line O.K?
SearchOrder:=xlByRows

**VBA Noob** · 01-22-2007, 05:27 PM

Did the example work

VBA Noob

**greasybob** · 01-22-2007, 05:36 PM

Not yet,
I must be doing something wrong. How do I get it to select the column with today's date?

**VBA Noob** · 01-22-2007, 05:52 PM

Argh,

I was selecting the cell and you want the column

Try

Please Login or Register  to view this content.

VBA Noob

**greasybob** · 01-22-2007, 06:28 PM

Great,
It's working. Thanks so much for the help.
I'm leaving now but will play with it some more tomorrow.
Appreciate the help...this stuff is fun.
Bobby

**VBA Noob** · 01-22-2007, 06:29 PM

No problem

Thanks for the feedback

VBA Noob

**dancing-shadow** · 11-04-2011, 03:37 PM

Apologies for the necro, but I'm trying to do the same thing - only my dates are in column B, and are not in any formula. I need to run this macro to find todays date whenever run (or clicked, if a button can be added somehow?)

I've tried:

Please Login or Register  to view this content.

...and looked at the example sheet, but when I go into Macro (Alt+F8) to run it, there is nothing there to run... This is the first time I've properly tried to use/make any macro, so I need baby-instructions please

Thanks

**protonLeah** · 11-04-2011, 06:00 PM

... so I need baby-instructions ...

:
#1. Please read forum rule #2
#2. Start your own thread

**dancing-shadow** · 11-05-2011, 03:27 AM

Originally Posted by protonLeah

:
#1. Please read forum rule #2
#2. Start your own thread

Apologies - used to another forum where they'd rather same questions go in the same thread, rather than having 200 seperate threads all asking the same things... Makes searching for answers easier if it's all in one thread, rather than having to trawl through loads... Different strokes for different folks...
New thread started.