Making a collection of EntireRows for copying and then deleting
Let us see what you have.
"Bill Case" wrote:
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
|