hmmm...

I would define a Range object and set it manually.
Like this :

Dim r as Range
...

set r = Sheets("PG&E").Range("A1:B5") 'the address of the table

r.AutoFilter 1, frmECR.cboAccountNumber


---
Message posted from http://www.ExcelForum.com/