VBA code to open a sheet at the current date in a row

[snmark]

Hi guys, can anyone help me with this please. I have a sheet with dates in column B going all the way down to December 31st ( 31/12/2023). I'd like a code to have the sheet open at the current date if that's possible. Thank you

stephen

 

[Legacy 143009]

In the VBA window, double click to Workbook on the left pane. Paste this code into workbook:

Private Sub Workbook_Open()
  Worksheets("Sheet1").Cells(Application.Match(CLng(CDate(Now)), Range("B:B"), 0), "B").Select
End Sub

 

[snmark]

In the VBA window, double click to Workbook on the left pane. Paste this code into workbook:

Private Sub Workbook_Open()
  Worksheets("Sheet1").Cells(Application.Match(CLng(CDate(Now)), Range("B:B"), 0), "B").Select
End Sub

In the VBA window, double click to Workbook on the left pane. Paste this code into workbook:

Private Sub Workbook_Open()
  Worksheets("Sheet1").Cells(Application.Match(CLng(CDate(Now)), Range("B:B"), 0), "B").Select
End Sub

Thank you Flashbond, works a treat!

 

[Legacy 143009]

Glad it did work! Thanks for the feedback

 

[Fluff]

In future please mark the post that contains the solution, rather than your post saying it works. Thanks