Without seeing your macro, we have no idea. Please read: Tip: How Do I Get The Best Answer in the Shortest Time?
For more information, see the wiki Searching the Forum for Answers section.