HI,

I have a spreadsheet that I'm working on and I want it to select the cell that corresponds to today's date when you open the workbook

I already have the following that does a few other things when you open the workbook and need to incorporate it into this code:

The sheet "Rota" is the sheet with the list of dates on: I have attached an example for ease as once I've got the code I can figure out how to incorporate it.
dates test.xlsx
Private Sub Workbook_Open()

Application.ScreenUpdating = False

Sheets("Current Week").Cells(3, 4) = Sheets("Current Week").Cells(5, 5)
With Worksheets("Current Week")
        .Activate
        .Range("D3").Select
    End With
    Sheets("Rota").Activate
    
    Application.ScreenUpdating = True
    
End Sub