Filtered copy and paste error

  • Thread starter Thread starter Bagia
  • Start date Start date
B

Bagia

I am trying to copy/paste the filtered on my worksheet of about
140,000 rows. I do this every month. unfortunately, I am getting the
following
error now:

Microsoft Office Excel cannot create or use the data range reference because
it is too complex. Try one or more of the following:

- Use data that can be selected in one contiguous rectangle.
- Use data from the same sheet.

Both of the above apply to my selection. Is there a limitation? If so, what
is it?

Thanks in advance.
 
Hi Bagia

Yes there is a limit of 8192 seperate areas

You must do it parts or sort the data so there are less areas
 
Back
Top