I have a server log that has start and stop messages (in one column) and corresponding times (in an adjacent column).

I am trying to get the time in the stop row and the time in the start row and copy them to a new cell in the start row. Then I subtract them to get the total down-time of the server.

I have a search using the following code:

Please Login or Register  to view this content.
This works perfectly for the first instance but then stops. Do I use .FindNext for the next instances of pairs or run a loop?

Even a point in the right direction is appreciated.

thx all.