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.