I'm trying to copy and paste something I've filtered in a spreadsheet. I've
done it before, but for some reason, it won't cooperate now. I'm using 2007,
if that makes any difference. I'm filtering one of the columns, copying the
using paste special. I've pasted using Paste Special, the Values and Number
format. Normally that will paste in only the filtered rows. This time it
continually pastes in the pre-filtered list. It's maddening. How can I paste
only what I've filtered or sorted?