Record a macro when you change all the settings you want. Click on the Options
button if you don't see all of them.

Then your recorded macro will show you all the parms you should be specifying.

keri wrote:

Hi,

I have code to look for the word TOTAL in a sheet

set rng = .find(What:="TOTAL")

however this finds cells that have total included anywhere in the
cell
eg Total Order
VAT Total

etc etc

I only want to find cells that the contents = TOTAL and I cannot
figure out a way to do this.

--

Dave Peterson