11-30-2007, 11:38 AM
Or
Excel.Range r=a.ws.Range("A1")
Don't know why Excel does not like r.AutoFilter(@ @ 1). But in QM you cannot use r.AutoFilter() if some arguments are not VARIANT.
In VBScript, r.AutoFilter works, but r.AutoFilter , , 1 fails like in QM.
Excel.Range r=a.ws.Range("A1")
Don't know why Excel does not like r.AutoFilter(@ @ 1). But in QM you cannot use r.AutoFilter() if some arguments are not VARIANT.
In VBScript, r.AutoFilter works, but r.AutoFilter , , 1 fails like in QM.