Checking Against Excel List via QM

[philipq]

See below code, I am trying a work around to get the used range in colum G, dynamically
Could you help me out with the queries in comments:
Macro NC VCC Release Corrections

Code:

Copy      Help

ExcelSheet es.Init
es.Activate(1 "VCC Release Spool") ;;Activate Sheet
es.Activate(4) ;;Bring Excel Window Forward

es.SelectRange("G:G") ;;How to get the used range here?
Excel.Range tempRange = es._Range("sel")
str tempStr=tempRange.Address ;;How to convert the address fo the used range to string?

es.CellsToArray(tempCell tempStr)

for r 1 tempCell.len ;;for each row
,if tempCell[0 r].len
,,out tempCell

Or below is a Excel VBA solution; would it be possible to implement something like in this in QM and use the count in for loop?

Range("A" & Rows.Count).End(xlup).Select
int r=Selection.Count