I've the following problem. When the the below code runs i get
"Autofilter method of range class failed". It says the problem is wit
the last line of code. The strange thing is that it even filters th
selected range, but it still has a problem with it.


If frmECR.cboVendor.Text = "PG&E" Then
Sheets("PG&E").Range("ListPGE").AutoFilter _
Field:=1, _
Criteria1:=frmECR.cboAccountNumber

This thing is driving me nuts. Any help you guys can give would b
appreciated.

Thanks

Jame

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