An error message

[plainme]

What does the following error message means?

Run-time error '9'
Subscript out of range

Thanks!

 

[plainme]

userform.

Thanks.

 

[djreiswig]

Maybe a stupid question, but you do have a commandbutton named CommandButton1 on your userform?

 

[plainme]

yes. thanks

 

[djreiswig]

I'd say it is probably being caused somewhere else in your code. Try taking all of your code out of this sub and replacing it with

MsgBox "This works"

just to prove that the code is not the problem.

 

[plainme]

Not the cause of the error, but you have screenupdating = false at the beginning and end of your sub. Should one of those be true?

It actually works on other workbook. I just modified the code.

 

[plainme]

I'd say it is probably being caused somewhere else in your code. Try taking all of your code out of this sub and replacing it with



just to prove that the code is not the problem.

I tried and it works. Thank you!

 

[djreiswig]

Yeah, it will work. You can have it in there 10 times, but it doesn't do anything differently than just turning it off once. Usually you turn screenupdating off while you are running code that changes things on the screen and then you turn it back on when you are done.

Did you try removing the code from the sub?

 

[djreiswig]

Well, if that works and the msgbox shows up, then it must be in the code. Try putting it back one piece at a time until it doesn't work anymore. This should let you know where the problem is.

 

[plainme]

Yes, I just did it and still doesn't work.

Thanks!

 

[djreiswig]

What part of the code did you put back that made it not work?