Link to home
Create AccountLog in
Avatar of Rayne
RayneFlag for United States of America

asked on

Robust VBA for deletion

Hello All,

I need a robust vba ode that does this.
This robust function takes in a string and worksheet as parameters.

For example
myFunc (“Aron”,sheet1)
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
ASKER CERTIFIED SOLUTION
Avatar of gnazareth
gnazareth
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Rayne

ASKER

works like a charm
thank you :)