Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time error '11' & Run-time error '1004'
"Piers Clinton-Tarestad" wrote in message news:... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time error '1004 | Excel Discussion (Misc queries) | |||
Run Time Error '1004' | Excel Worksheet Functions | |||
Run time error 1004, General ODBC error | New Users to Excel | |||
Run Time Error 1004 | Excel Programming | |||
Run-Time error '1004' | Excel Programming |