find time value in string

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?
 
L

Lars-Åke Aspelin

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting short times 2
Change "Text Like" to "Greater than" 3
highlight based on criteria in string 1
Time issues in code 6
Data Validation when entering hours over 24 8
How to enter start and end date/time in excel based on some specific value. 7
Ping - Bernie (or any other sage) 4
single cell time entry as time - time; Ever seen this? 12

Top