Search for a number in a row

[M_Gross]

Hi everyone,

I am struggling in VBA to find those cells in a row that contain a number.

The aim is to find every cell in a certain row with a number in it an delate the whole column.
A further Problem might be that the number is not declared as numeric, but as a text.

Can anyone help me out with this?

Best regards,
Max

 

[M_Gross]

Thanks a lot. It works perfectly (not surprising for you I guess)