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.

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

Thanks. In case anybody is interested (I doubt it as it was a silly
question with a simple answer) it was the xlWhole part I was missing.

Recording a macro to get the code is a very useful technique.

keri wrote:

Thanks. In case anybody is interested (I doubt it as it was a silly
question with a simple answer) it was the xlWhole part I was missing.

--

Dave Peterson