Hi all,
Newbie here.
I have a list of 16 9-digit numbers.
I have a worksheet with approx 1,000 9-digit numbers in Column A and other data in other columns.
I would like to use VBA to delete all rows in which one of the 16 9-digit numbers is in Column A.
I thought of placing the 16 9-digit numbers in an array and deleting rows based on comparing Column A with this array but can’t work out how to do it
Is this possible?
I have searched around and can’t find exactly what I’m looking for, and have had some success in deleting single rows, but not all of them.
I can’t post my code as I’m currently in the train….but I’m thinking I’ll have to start from scratch again anyway.
Newbie here.
I have a list of 16 9-digit numbers.
I have a worksheet with approx 1,000 9-digit numbers in Column A and other data in other columns.
I would like to use VBA to delete all rows in which one of the 16 9-digit numbers is in Column A.
I thought of placing the 16 9-digit numbers in an array and deleting rows based on comparing Column A with this array but can’t work out how to do it
Is this possible?
I have searched around and can’t find exactly what I’m looking for, and have had some success in deleting single rows, but not all of them.
I can’t post my code as I’m currently in the train….but I’m thinking I’ll have to start from scratch again anyway.