Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by pariah07
-
macro - jump to today on work sheet
Actually above is wrong Sub FindDate() Dim c As Range Set c = ActiveSheet.Cells.Find(what:=Date, LookIn:=xlValues) If Not c Is Nothing Then c.Select End Sub this code works, but the formate of the date must be xx/xx/xx- pariah07
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
macro - jump to today on work sheet
Well using Macro recorder i was able to Make it happen. Heres what it looks like. (ps i have know idea how or why it works) Sub Today_Find() ' ' Today_Find Macro ' ' Keyboard Shortcut: Ctrl+t ' Were "Range("Date")" =today() Range("Date").Select Selection.Copy Cells.Find(what:=Date...- pariah07
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
macro - jump to today on work sheet
Help!! im trying find a simple macro or vba code that when ran it will select todays date on the excel worksheet.- pariah07
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
