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?

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