Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Private Sub Workbook_Open()
- Dim R As Range
- With Worksheets(1).Range("A:A")
- Set R = .Find(Date, LookIn:=xlValues)
- If R Is Nothing Then
- Exit Sub
- Else
- .Cells(R.Row).Select
- End If
- End With
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement