Pasting Filtered Data

[starbwoy]

Hi Everyone- I'm filtering a lot of data (65533 rows) and I need to paste a filtered data set to another location. I have been reading through most posts and F5->Special -> Visible Cells Only, seems to be fixing most of these problems. However when I try F5->Special -> Visible Cells Only, I get the message

"Micrososft Office Excel cannot create or use the data range reference because it is too complex"

Any ideas?

Thanks.

[starbwoy]

Hi Everyone- I'm filtering a lot of data (65533 rows) and I need to paste a filtered data set to another location. I have been reading through most posts and F5->Special -> Visible Cells Only, seems to be fixing most of these problems. However when I try F5->Special -> Visible Cells Only, I get the message

"Micrososft Office Excel cannot create or use the data range reference because it is too complex"

Any ideas?

Thanks.

You have to only select the data, not the entire row or column, for small amounts of data. This dosent work for large amounts of data.