Checking Against Excel List via QM

[philipq]

1) Ok so how do I write ActiveCell.Offset(0,1) in QM?
2) And if I don't use SelectRange below, how do I select the used range to be stored in cellsToArray
Macro NC VCC Release Corrections

Code:

Copy      Help

es.SelectRange("M:M" 1) ;;obtain used range
es.CellsToArray(SANamesMaster "sel") ;;Obtain Master list of Sales Advisor Names from 'Data' Sheet

3) Plus, how do I loop/offset through ExcelCells in G coloumn without first setting cursor to G1?
Any better ways