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.