It sounds like 1 command within the macro causing the prolem

Post a copy of the macro & also state which command is causing the error

P.S Don;t forget to wrap your macro code when you post it