Hi All;

I think I am doing things the hard way. It is taking me about 50 lines and
looks awfully hacky. All suggestions gratefully received.

I have a small data base (30-40 members of a local club). I want the user
to be able to flag with an 'X' expired memberships in one column of the data
row. I want a procedure to do the following:

Loop through the range of members;
Pick out the 'X' members;
Save the address of the EntireRow of the membership info as a collection of
IntireRow addresses;
Then using the list/collection of Xed rows
Copy the IntireRow data and paste special (values) to an archive file;
Then delete the marked 'X' membership IntireRows;

I have something that kinda works, but it is long, messy and has to be
easier, neater.

Just some suggested key objects, methods and/or commands would be helpful.

Regards Bill