i can't figure out what's wrong with this code:


Code
-------------------

Private Sub cbMSA_Change()
If cbMSA.Value = "Please select MSA" Then
Range("D42:Y42").AutoFilter Field:=2
Else
Range("D42:Y42").AutoFilter Field:=2, Criteria1:=cbMSA.Value
End If
End Sub

-------------------


i copied and pasted from another section and made the necessary change
to the names. i get: run-time error 1004: autofilter method of rang
class failed.

any ideas

--
dream
-----------------------------------------------------------------------
dreamz's Profile: http://www.excelforum.com/member.php...fo&userid=2646
View this thread: http://www.excelforum.com/showthread.php?threadid=54963