QTP / Excel / Autofilter
I'm trying to filter on two columns.
First filter column A on myvar1
Second filter results using column B on "<> Blank" and <> myvar1
LastRow = objWorkSheet.UsedRange.Rows.Count
LastColumn = objWorkSheet.UsedRange.Columns.Count
objWorkSheet.AutoFilterMode = False
Here's the problem child...objWorkSheet.Range ???
Want to continue to filter on column B ...for criteria 1 <> myvar1 OR criteria2 <> Blank Cells in column B too
any help would be greatly appreciated