All the help options give directions on how to look for duplicates within a
worksheet, but I want to check for all duplicates in all the worksheets
within one book. Please help, thanks!

Hi,

Why don't you give us an example of what you mean. For example, if the
letter a is in A1 you want to see if the letter a is anywhere else in the
workbook? What if the letter a is in a word like "anywhere"? Do you want to
check numbers, text, dates? What do you want to do when you find them?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"jalas" wrote:

All the help options give directions on how to look for duplicates within a
worksheet, but I want to check for all duplicates in all the worksheets
within one book. Please help, thanks!