Macro to remove certain lines based on barcode format

Hello everyone,

I have a long spreadsheet of items with various barcodes.
What i need to do is remove every line with a barcode that includes one or more letters, so the table will only include numeric codes.
I searched through loads of code examples on how to delete lines, but i'm not really good with VBA and wasn't able to get anything working.
Been thinking maybe to use IF but i got hit by errors and crashes.

I already use a piece of code to make sure shorter barcodes get some 0es in front of them to up them to the 13 digit standard, and copy in a different cell.

Please Login or Register  to view this content.

Any help would be much appreciated.

Cheers,
Alex

Please Login or Register  to view this content.

HTH

Originally Posted by ciuncky

Amazing guys ! Thanks a lot , works wonders.
I need to set the Application.ScreenUpdating = False back up, kills my eyes now

Rep added to both
Cheers !

Thanks for the rep Please mark the thread as solved if you're done!