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.