Thread: Sheet and Cell selection based on date

I need help. I am working on a project in which I have a sheet for every day of the month, they are in mmmm format. Each sheet has every day in m/d format. I want excel to autoopen to the sheet that corresponds with the current month while the cursor lands on the cell to the cell that is to the left of the cell that has the current m/d date.
Here is what I have now (all it does is open to the right month):

Sub auto_open()
r = Format(Date, "mmmm")
Worksheets(r).Select
End Sub

Thanks!

Which column has the dates? What format are the dates? Is it text? Or a real date formatted to show month and day? Is there just one row for each day? Do the days start in cell A2? A1? B2? Whatever?

If there is one row for each day, starting in cell B2, the cell to the left would be:

Range("A" & Day(Now)+1).Select

Regards