I'm receiving the following error when trying to run a recorded macro:
"Run-time error '1004': Cannot use that command on overlapping selections."
It was successful when I recorded it, but when I tried to run it on a new sheet, I received the error. My code:
Sheets("Innovation Mapping Project - Re").Range("A1:MX29").AdvancedFilter _
Action:=xlFilterCopy, CriteriaRange:=Range("A1:A2"), CopyToRange:=Range( _