Are you pasting from one sheet into another sheet in the same version of Excel?

The number of rows to be pasted cannot possibly exceed the number of rows in the
target sheet in that case.

What is the error message you are getting when you try to paste?


Gord Dibben MS Excel MVP

On Mon, 17 Dec 2007 09:27:00 -0800, PayPaul
wrote:

I'm trying to paste in a lot of rows from a single column into another
worksheet. It seems as though the amount of those rows exceeds the number of
rows present in the worksheet. Is there a workaround? Is there a way of
adding additional rows to the maximum default number allowed in Excel 2003?