Find value in any Excel sheet via QM

[philipq]

I am adapting your above code to my usage as shown below.
I am having trouble with using varOptions which is a WindowText
Error message gives me a mismatch

Macro Amended Orders AL - VISTA Verification

Code:

Copy      Help

,for i 0 varOptions.n
,,str tempOpt=varOptions.a[i]
,,if x.Find(tempOpt c 2)
,,,r1=c[0].Offset(0 -1)
,,,varOptions.a[i]=r1.Value
,,,out F"col={r1.Column} row={r1.Row} value={varOptions.a[i]}"
,,else
,,,mes "Trim Not Found"