Looping the macro until it meet the condition.

Put your code into a Do Loop. I.e....

Please Login or Register  to view this content.

Thanks for suggestion.

But i am not getting exactly.

Below is the full macro.

Please Login or Register  to view this content.

So, you want to print once the value is F1 is >= 1 right?

Please Login or Register  to view this content.

Yes you are right, I want to print when F1 is => 1.

Many thanks it works.

Not a problem.

If this resolves your question, please mark the thread as Solved by clicking Thread Tools above your first post, and select "Mark your thread as Solved".