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?

"Bernard Liengme" wrote:

Chip has lots of stuff about duplicates. See www.cpearson.com
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"LiveUser" wrote in message
...
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 Liengme" wrote:

Try asking that again and use the white space to give MUUUUUCH more
detail
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"LiveUser" wrote in message
...