I have some code which searches through all the sheets in a workbook to find a specified string :
Set rngFound = rngSearch.Find(what:=strSearchText, LookIn:=xlValues, MatchCase:=False)
When it searches for ‘GBP’ it finds 6 references. However, when it searches for ‘gbp’ it finds none. I cannot understand why this should be so, as when I use Edit/Find & ‘gbp’ manually it finds 6 references.
Can anyone work out why this should be so
Usual thanks for your expert help
Nick