Please help.

I have a column I want to copy to another sheet. I just click the column
and copy there are 20738 rows.
Then I go to the next sheet and try to paste. I click the first cell in the
column, then with the shift and down arrow I go to row 20738.

I keep getting this error. There are the same number of cells.

Is there a simpler way to get to row 20738 than the down arrow or going to
the row and clicking.

anyway, how do I get rid of this error?

tia,

Copy the column just as you have been doing. Go to the other sheet and select
the first cell in the column (so long as you only have one cell selected XL
will figure out the paste area) and paste...
--
HTH...

Jim Thomlinson


"Janis" wrote:

Please help.

I have a column I want to copy to another sheet. I just click the column
and copy there are 20738 rows.
Then I go to the next sheet and try to paste. I click the first cell in the
column, then with the shift and down arrow I go to row 20738.

I keep getting this error. There are the same number of cells.

Is there a simpler way to get to row 20738 than the down arrow or going to
the row and clicking.

anyway, how do I get rid of this error?

tia,