Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-Time error '9' New Question
I have posted this problem before and didnt get it resolved, fishing again
hoping to get lucky. Here is my code: Dim wsSheet As Worksheet Dim rngNext As Range Dim myRange As Range Set wsSheet = ActiveSheet With wsSheet Set rngNext = .Range("F65536").End(xlUp).Offset(1, 0) End With rngNext.Select Set myRange = Range("F2", rngNext) 'populate Group combobox list With combStation Selection.End(xlUp).Select For Each rngNext In myRange If rngNext = "" Then Selection.End(xlUp).Select End If .AddItem rngNext Next rngNext End With Here is my problem: When I have the worksheet set at: Set wsSheet = ActiveSheet The userform works as planned and I continue. When I try to set it to: Set wsSheet = Worksheets("List1") I get a Run-Time error '9': and the userform fails. I have isolated the problem to that line a code. I tried the obvious and saved the workbook. From there I need ya'll help. Also with the help of a few members here I have also ruled out adding the code setting the workbook. Any help you can give me would be most appreciated. Thanks in advance, Ryan -- Fighting Texas Aggie Class of 2009 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
run time error 1004 general odbc error excel 2003 vba | Excel Programming | |||
Error handling error # 1004 Run-time error | Excel Programming | |||
Run-time error question | Excel Programming | |||
VBA Run-time Error "13" - Question | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming |