find time value in string

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
J

J.W. Aldridge

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?
 
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?
Click to expand...

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
 
Back
Top