Hi

I'm looking to create a visual representation of a ball moving around a football/soccer pitch. The pitch is divided into 17 areas A through Q and those areas are set as cells within the worksheet. What I want is an arrow to connect the two cells imitating the movement as I run through the match. I have a sub for connecting cells with an arrow:
Please Login or Register  to view this content.
The bit I'm having trouble with is calling it as I cycle through the list of areas. This is my current sub:
Please Login or Register  to view this content.
So, the intent is for the top bit to define A through Q as those ranges. Once cycling through the Min values I want to call those letters which will appear in (Rows, 28) and (Rows+1,28) and join those two points by calling Connect, then wait a second before moving on to the next line.

Any ideas most welcome.