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
objWorkSheet.Range("A1:J"&LastRow).AutoFilter 1,"="&myvar1&""

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