Assuming the Macro is getting some type of error, this should help you identify it:
For more information, see the wiki Searching the Forum for Answers section.