Prev: How do I stop Excel from selecting more than one cell when clicked
Next: Insert row disappeared
From: Bagia on 21 Oct 2009 02:00
Hi Shane,

You mentioned that there's a limit to the number of discontinuous selections
that Excel can handle, do you know what the number is? I have 65K rows and
want to know the limitation so I know how many times I have to repeat the
steps of copying discontinous selections.

Thanks,
Bagia

"Shane Devenshire" wrote:

> Hi,
>
> When you filter data there is a limit to the number of discontinuous
> selections that Excel can handle. One solution is to sort the data so that
> like items are grouped adjacent. Then apply the filter and copy.
> Alternatively, you can select half of the filtered data and copy it, then
> select the other half and do it again.
>
> --
> If this helps, please click the Yes button.
>
> Cheers,
> Shane Devenshire
>
>
> "Tony7659" wrote:
>
> > I am trying to copy/paste the filtered (subtotals) on my worksheet of about
> > 17,000 rows. I do this every week. 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. Any help? Thanks.
> > Tony.
 | 
Pages: 1
Prev: How do I stop Excel from selecting more than one cell when clicked
Next: Insert row disappeared