Hi all,
I am trying to write a VBA code that will search the column and clear are cell with a specific value. For example, it will search column B for a cell containing the number "1". If it finds a cell contain "1", then that cell gets its contents cleared. I don't want it deleted so other columns and cells don't shift.
Thanks in advance for the help.
I am trying to write a VBA code that will search the column and clear are cell with a specific value. For example, it will search column B for a cell containing the number "1". If it finds a cell contain "1", then that cell gets its contents cleared. I don't want it deleted so other columns and cells don't shift.
Thanks in advance for the help.