getting error after copying&pasting results from VBA recorder into editor

I'm hoping someone can explain to me why I'm having difficulty. I put in a monster of an 'if' statement and used the VBA recorder to get it into VBA-speak. However, after copying and pasting the results into the code, I get the following message when it reaches that specific line:

"Run-time error '1004': Application-defined or objected-defined error"

Has anyone ever encountered this issue before?

I really hope to get some solutions without having to post the 'if' statement here. It's a doozy.

Thanks.