View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bagia Bagia is offline
external usenet poster
 
Posts: 46
Default Filtered copy and paste error

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.