Ike
02-10-2014, 06:48 AM
Hello All,
I've been searching for a code that will simply do the following.
I have a spreadsheet that has both shipment tracking numbers and serial numbers in the same column.
If in column "N" a cell is greater than 10 characters then delete the entire row. I want to keep all serial numbers that are 10 characters long without spaces or special characters.
The cells in the column will contain both alpha and numeric characters.
This code will be inserted in an existing VBA macro.
Thank you very much.
Ike
I've been searching for a code that will simply do the following.
I have a spreadsheet that has both shipment tracking numbers and serial numbers in the same column.
If in column "N" a cell is greater than 10 characters then delete the entire row. I want to keep all serial numbers that are 10 characters long without spaces or special characters.
The cells in the column will contain both alpha and numeric characters.
This code will be inserted in an existing VBA macro.
Thank you very much.
Ike