Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
code that searches for current date
tyring to get a code that searches column F for the very first
instance of the current date (i.e. 10/3) and stops on that cell |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
code that searches for current date
Range("F:F").Find(Format(Now(), Range("F2").NumberFormat), , xlValues).Select
This assumes that the formatting is consistent down column F, and F2 contains a date... HTH, Bernie MS Excel MVP "J.W. Aldridge" wrote in message ups.com... tyring to get a code that searches column F for the very first instance of the current date (i.e. 10/3) and stops on that cell |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
code that searches for current date
Sub findit()
n = Cells(Rows.Count, 6).End(xlUp).Row td = Date For i = 1 To n If Cells(i, 6).Value = td Then Cells(i, 6).Select Exit Sub End If Next End Sub -- Gary''s Student - gsnu200748 "J.W. Aldridge" wrote: tyring to get a code that searches column F for the very first instance of the current date (i.e. 10/3) and stops on that cell |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
code that searches for current date
On Error Resume Next
iRow = Application.Match(Date,Columns(6),0) On Error Goto 0 If iRow 0 Then ... -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "J.W. Aldridge" wrote in message ups.com... tyring to get a code that searches column F for the very first instance of the current date (i.e. 10/3) and stops on that cell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Current Date Code in form | Excel Discussion (Misc queries) | |||
Getting valid web searches and avoiding sites that contaminate web searches | New Users to Excel | |||
code an input field that asks for current date | Excel Programming | |||
Can I add the current date/time to my code when I print it? | Excel Programming | |||
code pasting a date changes date format in current month only | Excel Programming |