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.