That helps. Thanks Dave a lot for the solution.

Hank

"Dave Peterson" wrote:

Excel doesn't have any built-in support for this kind of pasting (to
non-contiguous cells).

Maybe you could sort your data first to make sure you're pasting into a
contiguous range--then sort it again in the order you want.

Or paste it visible area by visible area by visible area....

Hank wrote:

Hi, I have a worksheet which have been AutoFilter, I need to copy data from
other worksheet to filtered visible cell, how can I do that to paste
correctly??

Thanks a lot.

Hank

--

Dave Peterson