Advertisement
Guest User

Untitled

a guest
Feb 14th, 2019
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Private Sub Workbook_Open()
  2.   Dim R As Range
  3.   With Worksheets(1).Range("A:A")
  4.     Set R = .Find(Date, LookIn:=xlValues)
  5.     If R Is Nothing Then
  6.       Exit Sub
  7.     Else
  8.       .Cells(R.Row).Select
  9.     End If
  10.   End With
  11. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement