Quote Originally Posted by Kenneth Hobs View Post
You have an infinite loop unless your variable is a global one modified by the other routine.
Hi Ken

Thanks for your reply. Sorry I didn't make my request clear. The infinite loop is actually intentional. The issue I have is that the Excel application that runs this loop eventually closes with no warning message.
I was kindly asking for advice as to why this might be happening