If you're trying to paste a bunch of rows into the visible cells (discontiguous
rows), excel doesn't support this directly.

To make life easier, you could sort your data and paste in that contiguous
range.

Or you could use a macro that copies row by row and pastes into visible rows
(row by row).

http://groups.google.com/groups?thre...apeXSPAM.c om

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Jac wrote:

--
JacB

--

Dave Peterson