Run-time error '11' & Run-time error '1004'

  • Thread starter Piers Clinton-Tarestad
  • Start date
P

Piers Clinton-Tarestad

I have a drop down combobox((name)=AL_MLP) over and linked to cell D:24 with
options of "yes"/"no"/"n/a" to answer a question and if the answer is "no"
or "n/a" i have tried to hide the next question using the following code
(the next question is populated by a similar combobox over and linked to
cell d:25)

Private Sub AL_MLP_Change()
VarCurrentString = AL.AL_MLP.Value
If VarCurrentString = "Yes" Then
AL.Rows("25:25").Select
Selection.EntireRow.Hidden = False
End
End If
VarCurrentString = AL.AL_MLP.Value
If VarCurrentString = "No" Then
AL.Rows("25:25").Select
Selection.EntireRow.Hidden = True
End
End If
VarCurrentString = AL.AL_MLP.Value
If VarCurrentString = "N/A" Then
AL.Rows("25:25").Select
Selection.EntireRow.Hidden = True
End
End If
VarCurrentString = AL.AL_MLP.Value
If VarCurrentString = "" Then
AL.Rows("25:25").Select
Selection.EntireRow.Hidden = False
End
End If

End Sub

this works but the problem is if someone has already skipped forward to the
next question and filled it in then when the user trys to select "no" or
"n/a" the following errors occur

run-time error 11 division by zero

if i ignore this and try again i get

run-time error 1004 unable to set Hidden property of the range class

anybody know how i can fix this as I'm pretty stuck!!!
thanks
piers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top