Run time error '380': Could not set RowSource property. Invalid property value

[bdautrich]

Working on Excel VBA app. And I am getting an error I can not figure out.

The app is displaying a range from a spreadsheet in a list box on a user form, The first time it does this, things work fine. The user form has some text input boxes that allows the user to input a new row of data unto the spreadsheet. After the user clicks on the save button the VBA code calls the subroutine to reset the list box and the second time through, I get the 380 error. I put in a msgBox to see that the only parameter which is the row number of the last row is valid and it is so I do not have an idea what is happening. The strange this I have nearly identical VBD code that works the same way with a different spreadsheet, and I am not experiencing the error there.

Here is the code that

MsgBox ("In reset and iRow = " & iRow)

If iRow > 1 Then

.lstJoints.RowSource = "List1!A2:I" & iRow ' this is the line that generates the error

Else

.lstJoints.RowSource = "List1!A1:I1"

End If

Any help would greatly be appreciated.

 

[RoryA]

Are there any error values on the worksheet?

 

[bdautrich]

Are there any error values on the worksheet?

Not that I know of

 

[RoryA]

Are you sure iRow is valid when the error occurs? How is it declared and what is its actual value?

 

[bdautrich]

I am printing out iRow and it is a valid value and it is declared as integer.

Are you sure iRow is valid when the error occurs? How is it declared and what is its actual value?

 

[bdautrich]

That is why I am stuck

 

[RoryA]

I can't replicate your error if the address is valid. If the sheet name is wrong, or the row number is missing, then you would get that error. Does the Else part of the If code work if you make iRow equal 1?

 

[bdautrich]

I set IRow to 1 and the else part of statement worked. I then used the same code as the else statement with iRow > 1 and it worked. I changed it to A2:I2 and it worked and then I change the I2 to I concatenated with iRow and it now works. The only thing I can think of it somehow a non visible character was in the code somewhere throwing the reference off. Thanks for your help.