Delete the entire column that has single digit number - Part-2

Hi Guys,

I want a Macro that searches the entire sheet and deletes the entire column that has single digit number. The worksheet also has decimal numbers but it should not delete that. It should delete only the single digit number. I am uploading the excel file. In the excel file that I am uploading I want to get rid of Columns B and C. There are some single digit number in Column D and E but its just zero and it will always be zero. No other single digit number other than zero will be in Column D and E. Also the columns with single numbers will be randomly based anywhere at all times i.e they are dynamic. Please find the attachment.

Thanks in advance.

Cheers
plasma33

Hi jraj1106

Thanks for your kind reply. I need a macro that looks for all the column and deletes the whole column which has single digit number which over here is 0 and 1. In the excel file that I have uploaded I want to get rid of columns B and C. But the macro should not effect columns A, D and E because column D and E have single digit number which is 0. Hope I explained it well.

I have a code which does it for the rows. But deletes all the content.

Please Login or Register  to view this content.

Cheers
plasma33