Hello,
Please help me to write a code to accomplish the following:
..I have a list of account numbers listed in column A
(starting from the second row or A2)
..I need the macro to go down the list (while there is
still data) and determine if the account numbers are valid
(against the list of invalid account numbers)
..And if it finds the invalid account number it should
delete the entire row

Of course I can determine the invalid accounts by using
the VLookUp function and then manually delete the rows but
it would be great if it can be down automatically (via
macro).

Please help and thank you in advance.