In the attached:
To count passed vessels when the ships started their regular service, set cell B2 to 83 when the orange ship is very nearly half way across (that's how I left the attachment), just about to meet the blue ship which left from the other end at the same time, then click the Continue button and count the encounters(8)
To count the ships passing with an established schedule, move the scroll bar to the top (B2=0) and press the Continue button and count (15).
If you have a fast computer you may have to increase the delay in the macro (For j = 1 To 100: DoEvents: Next).
Last edited by p45cal; 01-29-2025 at 06:34 AM.
p45cal Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Reply With Quote