How do you paste data when autofilter is on?
 

--
JacB

Hi
- select the data range
- hit F5, click 'Special' and choose 'Visible cells only'
- now copy+paste your data

--
Regards
Frank Kabel
Frankfurt, Germany

"Jac" schrieb im Newsbeitrag
...

--
JacB

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