Hi, kalpeshpatel!
Am I wrong or this is a cross-posting of the same topic you stared earlier and that was responded by Luke M 13 hours ago?
http://chandoo.org/forums/topic/1st-macro-run-then-2-macro-is-run
If I'm not, please read the third green sticky post at this forums main page.
Specially the parts:
"Cross Posting, generally it is considered poor practice to cross post, that is to post the same question on several forums in the hope of getting a response quicker.
If you do cross post, please put that in your post.
Also if you have cross posted and get an answer elsewhere, have the courtesy of posting the answer here so other readers can learn from the answer also, as well as stopping people wasting there time on your answered question."
"Say "Thanks", whenever you can. Recognize when someone has bothered to go to the trouble and time to assist you with your question. Often readers will spend several hours working on a solution to a problem, a line of recognition will go a long way."
Regards!