I filtered a list, copied the filtered rows and pasted them. I got only the
filtered rows. No unfiltered rows. Excel 2007. Perhaps I'm misunderstanding
what you're trying to do.

"RHall" .(donotspam) wrote in message
...
What would be a good way to get data from a text range in workbook1 for
only
rows that meet a criteria. When I filter the data in workbook1 and then
do a
copy paste I get the unfiltered rows between the selected rows. The macro
to
do this was recorded as I did it step by step. Please help. I'm new to
Basic but was a programer in other languages. Thanks,

RHall
--
none