Chris_AAA
07-15-2015, 03:09 AM
Hi All
I have a worksheet, in which 'generally' column a will be numeric codes only. on the rare ocassion, column A will be mixed with alpha numeric data.
Im after some advice in which the code searches all of column, A, if alpha numeric, then delete whole row, and loop through till end. if no alpha numeric codes, then continue with rest of code.
Any help is greatly appreciated.
Thank you
Am sure its an easy solution, but its baffled me.
I have a worksheet, in which 'generally' column a will be numeric codes only. on the rare ocassion, column A will be mixed with alpha numeric data.
Im after some advice in which the code searches all of column, A, if alpha numeric, then delete whole row, and loop through till end. if no alpha numeric codes, then continue with rest of code.
Any help is greatly appreciated.
Thank you
Am sure its an easy solution, but its baffled me.