Hey @brijazz,
You didn't post your macro, so no one has any idea of what you're really doing. Therefore any advice given is mostly conjecture.
Please post the minimum possible “working” version of the macro.
The devil is in the details...
If you haven't read these they're worth a couple of minutes of your time.
How to Post Your Macro to the Forum
Tip: How Do I Get The Best Answer in the Shortest Time?
-Chris