Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
code failure
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
code failure
interesting. i have two separate pieces of code that do something, an now i'm just testing. whenever i run the first macro, the error pops u in the second one, even though cbMSA was not touched. what's going on? Code ------------------- Private Sub cbForm_Change() If cbForm.Value = "Please select formulary" Then Range("D42:Y42").AutoFilter Field:=1 Range("D42:Y42").AutoFilter Field:=2 Else Range("D42:Y42").AutoFilter Field:=1, Criteria1:="Last Update" Range("D42:Y42").AutoFilter Field:=2, Criteria1:="Abilene, TX" End If End Sub 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:="Abilene, TX" 'End If End Sub ------------------- -- dream ----------------------------------------------------------------------- dreamz's Profile: http://www.excelforum.com/member.php...fo&userid=2646 View this thread: http://www.excelforum.com/showthread.php?threadid=54963 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup failure & ctrl-f failure? | Excel Discussion (Misc queries) | |||
Mouse scroll failure when looking at code | Excel Worksheet Functions | |||
VBA Code Reference to Solver Failure ! | Excel Programming | |||
Chart versus Work Sheet Code Failure | Excel Programming | |||
add in failure | Excel Programming |