Hi Experts,
I prepare monthly MIS reports wherein every month in several tabs of excel sheet, i need to delete manual numbers. I need a separate VBA code for each sheet wherein code will loop through each and every cell let's say, in tab "A" of column B to Z and row 1 to 1000 and if its find the manual numbers (not containing any formula or text) , it will delete the numbers.
I need a dummy code and then i will customize it according to the requirement of every sheet.
Thanks in advance.
I prepare monthly MIS reports wherein every month in several tabs of excel sheet, i need to delete manual numbers. I need a separate VBA code for each sheet wherein code will loop through each and every cell let's say, in tab "A" of column B to Z and row 1 to 1000 and if its find the manual numbers (not containing any formula or text) , it will delete the numbers.
I need a dummy code and then i will customize it according to the requirement of every sheet.
Thanks in advance.