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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Bagia" wrote in message
...
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.