No need. After autofiltering, just copy the visible rows using specialcells

Set rngToCopy = rngFiltered.SpecialCells(xlCellTypeVisible).Entire Row

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"RBLampert" wrote in message
...
I'm trying to create a macro in Excel 2002 which will select certain rows
of
a worksheet using the Autofilter capability. The (non-contiguous) rows
will
then be copied to another worksheet within the file. The number of rows
selected will range from zero on up. Since the number of rows will be
different each time, and I don't know how to get Excel to deal with that
variability, I want to have the macro pause to let the user select the
rows
to be copied, then continue once the selection is made. (Assume the user
will have only minimal skills with Excel.) How do I pause the macro, let
the
user can make his/her selections, then resume the macro? I have VERY
LIMITED
VBA programming skills.