Quote Originally Posted by jaslake View Post
Hi BigBlackMamba

What you have may work well in a static world (sheet 1 is not being updated). I've no idea what happens when sheet 1 is being updated the same time the procedure runs on the timer. Guess we'll find out.

If your immediate issue is resolved, please mark your post as "solved". A click on the scales is appreciated if you feel it;s appropriate.

John
Yes indeed......I ran it over static data with 700 rows and it worked very nicely but the acid
test really will be with streaming data......fingers crossed!! Thanks again for your help - I suspect you've written one or two programs in your time