B
Barb Reinhardt
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
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