I need a robust vba ode that does this.
This robust function takes in a string and worksheet as parameters.
will delete all the columns that has occurrences of Aaron within sheet1 at row 2
Also criteria for clearing will be that the target string should be part of the entire cell value,
For example - if a cell has Aaron 3455 then then cell will not be cleared. So xlWhole, not xlPart