Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Find value in any Excel sheet via QM
#2
Macro Macro2494
Code:
Copy      Help
str var1 var2 var3
var1="Sheet1"
var2="e"

ExcelSheet x.Init(var1 1)
ARRAY(Excel.Range) a
if x.Find(var2 a 2)
,Excel.Range r=a[0].Offset(0 -1)
,var3=r.Value
,out F"col={r.Column} row={r.Row} value={var3}"


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)