Hello,

I have tested that for Excel 2007, the copy visible cells only can work for
only fiew numbers of rows. My spreadsheet has more than 55 000 rows and when
I do filtering and I want to copy only visible cells, it can not works it
says it is too complex.

Is there anyway to solve this problem. I have to separeae all the 2006
Purchas Order lines since excell has only 65000 lines plus.

Thanks for any idea provided.


--
H. Frank Situmorang