Hello,

I have a string of data in a spreadsheet which only appears in column A of my spreadsheet. I would like a VBA Excel code to delete all rows that do not contain a number in the row. I thought that this would be easy, but I am having trouble finding the correct code to delete the cells which do not contain a number. My string is alphanumeric.

17320FAB9 CMLTI 12-A B 8.3/8.3 5 11 10 6/24
17320FAE3 CMLTI 12-A C 2.1/2.1 0 0 10 6/24
* Bids accepted for either size.
My name is Tom
I
Henry
02660TDH3 AHM 05-1 6A 1.9/0.4 L+200 14.3 15 5/25 L90s
126671RM0 CWL 02-3 1A1 0.6/0.0 L+37 54.9 15 HEQ
07386HKN0 BALTA 04-7 M 0.4/0.2 2.6 9.9 13 5/25
45660HAA6 INDX 06-AR21 A1 0.6/0.2 L+12 0 31 5/25

I would like to delete the lines that do not have a number in it. This data can vary on a daily basis, thus the code cannot be specific to what I have posted here. If there is someone that can help me out, that would be great.