Excel 2010 Not able to run my Macro

We have a number of Macros that were built using Excel 2003 (and ran fine) that are now not able to run using Excel 2010. I'm guessing it is some type of syntax issue, but I haven't been able to find anything specific to this issue online, so that's why I'm here.

I am receiving the following error on the "Selection.Entirerow.Insert" line:

"Run-time error '1004': The information cannot be pasted because the Copy area and the paste area are not the same size and shape."

Essentially we are copying rows from one spreadsheet to another based on certain criteria.

Please Login or Register  to view this content.

Any help is much appreciated!

Doug Walker

Maybe try this revised version (not tested):

Please Login or Register  to view this content.

Knew I was going to have to test it.

Shortened (working version):

Please Login or Register  to view this content.

Works like a charm. Much appreciated. A few questions in response if you don't mind.

Care to explain why my previous code broke? Was it just a syntax change through the versions as I wondered?

Also, I did add in one line to the If statement within the For.

Please Login or Register  to view this content.

We have a large amount of data, and otherwise the user receives a message asking them to clear the clipboard.

Thanks Again!

I don't really know that I have not used Excel 03 for a while now, and even then I wasn't using vba. It might be that this line:

Please Login or Register  to view this content.

was trying to add more lines that the worksheet has. In my adjusted code, I just pasted instead of inserting lines.

Also instead of looping through all the rows in the sheet, I limited it to only the first cells that have information in Column B.

Hope this helps.

Good luck.

abousetta