Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find time value in string
string of times in F2:F100.
How to find (and go to) the first instance of cell value that is greater than 00:30:00 am? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
find time value in string
On Sat, 27 Jun 2009 06:16:09 -0700 (PDT), "J.W. Aldridge"
wrote: string of times in F2:F100. How to find (and go to) the first instance of cell value that is greater than 00:30:00 am? Tty this sub: Sub go_to_first_cell_greater_than() For Each my_cell In ActiveSheet.Range("F2:F100") If my_cell.Value TimeValue("00:30:00") Then my_cell.Select Exit Sub End If Next my_cell End Sub Hope this helps / Lars-Åke |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find String in another string - only between spaces | Excel Worksheet Functions | |||
Find Many String options in ONE String | Excel Worksheet Functions | |||
Function to convert Time String to Time | Excel Worksheet Functions | |||
backwards find function to find character in a string of text | Excel Programming | |||
find a string inside another string | Excel Programming |