How can I delete all matches in a workbook?

  • Thread starter Thread starter LiveUser
  • Start date Start date
Try asking that again and use the white space to give MUUUUUCH more detail
best wishes
 
Yes. I am sorry. I sent the post before I typed the message.

Here is what I am trying to do.

I have maybe 30 or so worksheets. On each one there is information that may
or may not relate to each other. For instance, worksheet one has, Blue,
Green, Yellow, Orange. Worksheet two has Blue, Red. Worksheet three has Red,
Purple, Orange, Blue.

I want to delete, in this example, ever color listed throughout the entire
workbook without having to go through every page finding it and deleting it.

I would like to just make a list that has:

Red
Orange
Yellow
Green
Blue
Indigo
Violet

Anything that matches this list will be deleted in the workbook. (In my real
workbook I am not using colors.)

I appreciate any help. And again, I am sorry for the mistake on the original
post.
 
Bernard:

Thank you for the info. I am not sure which VBA code, if any, I should use.
I don't know if what I want is possible?
 
Back
Top