Hi,
I am trying to create a combobox within a userform that pulls its items from a dynamic range called "Options_Port" "=OFFSET(Options!$B$9,0,0,COUNTA(Options!$B11:$B103),1" on a worksheet called "Options". I am not sure if it matters, but the worksheet "Options" is hidden.
I have verified the range is correct and definately pulling up data.
When I try to run the following code, I get a Run-time error '1004': Method 'Range' of object '__Global' failed.
I have also tried explicitly naming the range by calling it from ActiveWorkbook etc, but I still get the same error. Please help!
I am trying to create a combobox within a userform that pulls its items from a dynamic range called "Options_Port" "=OFFSET(Options!$B$9,0,0,COUNTA(Options!$B11:$B103),1" on a worksheet called "Options". I am not sure if it matters, but the worksheet "Options" is hidden.
I have verified the range is correct and definately pulling up data.
When I try to run the following code, I get a Run-time error '1004': Method 'Range' of object '__Global' failed.
I have also tried explicitly naming the range by calling it from ActiveWorkbook etc, but I still get the same error. Please help!
Code:
Private Sub UserForm_Initialize()
PortSelect.List = Range("Options_Port").Value
End Sub