VBA
Posted: Sun Jun 18, 2023 1:10 pm
Hi there!
I have got a problem.i have a date range in column B .my purpose is to select today date when workbook open.
Tks
I have got a problem.i have a date range in column B .my purpose is to select today date when workbook open.
Tks
Code: Select all
Private Sub Workbook_Open()
Dim Fnd As Range
Set Fnd = Sheets("Sheet1").Range("B:B").Find(Format(Date, "dd/mm/yyyy"), , xlValues, , , , , , False)
If Not Fnd Is Nothing Then
Application.Goto Fnd,True
End if
End Sub
Please try this statement.