Checking Against Excel List via QM

[Gintaras]

Click CellsToArray in the code editor and press F1 or look in status bar. It shows

range examples: "" (all), "3:3" (row), "C:C" (column), "A1:C3" (range), "sel" (selection), ExcelRow(row) (row as variable). flags: 1 date as number, 2 formula, 3 text

Macro Macro2575

Code:

Copy      Help

ExcelSheet es.Init

;es.SelectRange("G:G") ;;don't need for CellsToArray
ARRAY(str) a
es.CellsToArray(a "G:G")
;es.CellsToArray(a "sel") ;;if need intersection of selection and used range
out a.len