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