http://www.google.com/search?sourcei...+in+filt ered

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Barb Reinhardt" wrote in message
...
I've stumbled across an issue with autofilter. Let's say you autofilter
your data and rows 3 and 4 are hidden by the filter. You then select a
range from row 2 to row 5 and paste data in it. In this case, the pasted
data is only entered in row 2 and row 5 only. If you do the same thing
with
PASTE SPECIAL, data is entered into the selected cells from row 2 through
row
5, including the hidden cells. Is this a bug? If so, how does it get
reported? I've tested it in both Excel 2003 and 2007 and get the same
result.

Thanks,

Barb Reinhardt