Hi, I'm using a combo box to work as an autofilter, but since there's totals included I'm using it. I've set the code of it as
If ComboBox1.Value = 710 Then
Rows("16:244").Hidden = True
End If
However when I run it I get an error message, even though the rows are hidden. Is there a way to disable the debug dialog box brought up??? Or is there another way to write the code to make it work?
Thanks
If ComboBox1.Value = 710 Then
Rows("16:244").Hidden = True
End If
However when I run it I get an error message, even though the rows are hidden. Is there a way to disable the debug dialog box brought up??? Or is there another way to write the code to make it work?
Thanks