copy and paste in chunks--so you only past to visible cells.

create_share wrote:

i am pasting data from one sheet to another sheet where i have some hidden
cells as well. But when i paste the data, it is pasted on hidden cells as
well. Is there a way to avoide this so that i should not paste data on hidden
cells???

thankx!

--

Dave Peterson