The information cannot be pasted because the copy area and the paste area are not...

You shouldn't be copying ENTIREROWs unless you really want to paste entire rows. Typically, an entirerow command it targeted at a cell in column A, yes? Else, where are the leftover cells at the end of the "entirerow.copy" command supposed to go when you bump off the end of the row? That's what's causing the error.

If your design doesn't support your need, post your workbook demonstrating some BEFORE/AFTER examples so we can see what you really need, visually.

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.

I do want to take the entire row of P and stick it below O. I just don't know how to do it that way because O will have empty cells but there will be cells with content after those empty ones. So I will never know which is last cell in O just by checking if a specific cell is empty or not, because if it is empty, that doesnt necessarily mean that it is the last. I also dont want to override any cells with content in O but I want to also ensure all the Ps end up in O. It is really something simple I am trying to do:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The results after the macro:

Please Login or Register  to view this content.

YOu talk about copying entire rows and then post an example showing single cells from column P being pasted below the current data in column O, nothing to do with entire rows at all.

This is why I told you to post an example workbook showing the full scope of what you wanted to do. IF the full scope is really as simple as:

"Move the data in column P to the bottom of the data in column O preserving any blank spaces in the layout."

...that's way simpler than the code you've got.

Please Login or Register  to view this content.