Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Object defined errror
Help please
I have the following code, and when I step through it using F8 key it highlights the third line as an error. Any ideas????????? Private Sub SelectArguments_Click() EngIndex = EngineSelect.List(EngineSelect.ListIndex, -1) Set inputrange = Range("Parameter_List") Set Inrng = Range(inputrange(1, EngIndex + 1), inputrange(inputrange.Rows.Count, EngIndex + 1)) For Each Cell In Inrng If IsEmpty(Cell.Value) Then Exit For Else UserForm1.ListBox2.AddItem (Cell.Value) End If Next UserForm1.Show End Sub |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Object defined errror
Maybe you don't have a range named Parameter_List on the worksheet.
N.F wrote: Help please I have the following code, and when I step through it using F8 key it highlights the third line as an error. Any ideas????????? Private Sub SelectArguments_Click() EngIndex = EngineSelect.List(EngineSelect.ListIndex, -1) Set inputrange = Range("Parameter_List") Set Inrng = Range(inputrange(1, EngIndex + 1), inputrange(inputrange.Rows.Count, EngIndex + 1)) For Each Cell In Inrng If IsEmpty(Cell.Value) Then Exit For Else UserForm1.ListBox2.AddItem (Cell.Value) End If Next UserForm1.Show End Sub -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
defined object | Excel Discussion (Misc queries) | |||
system errror &H8000FFFF | New Users to Excel | |||
Application-defined or object-defined error Please Help | Excel Discussion (Misc queries) | |||
Macro error : Application-defined or object-defined error | Excel Discussion (Misc queries) | |||
Do nested subtotals have an errror in Excel 2003 | Excel Discussion (Misc queries) |