Compile Error: Wrong number of arguments or invalid property assignment

[bobmaucher]

I've been struggling with this error message all day: Compile Error: Wrong number of arguments or invalid property assignment

I have a UserForm set up, and when I click submit, it runs some code (about 50 lines). However, it seems to get hung up in this section:

Please Login or Register  to view this content.

It highlights the first "Range" above and gives me the compile error. I commented out that line, and re-ran. It went to the next "Range" and highlighted that with the same error message.

I did some research, and it seems the typical culprit would be for me to have declared a sub somewhere else called "Range". But I looked, and there is no such sub called Range.


Any idea, or maybe something to look at first? I can't seem to make any progress debugging this one. Thanks.

[AB33]

I suspect this line

Please Login or Register  to view this content.

Have you tried stepping over the code using the F8? When you do, the code will stop on that line when there is an error.

[shg]

I expect what you meant was

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[bobmaucher]

I suspect this line

Please Login or Register  to view this content.

Have you tried stepping over the code using the F8? When you do, the code will stop on that line when there is an error.

That's correct, when I run the macro, the first word (Range) in that line you quoted is highlighted blue (not yellow, as I'm accustomed to seeing with VBA errors) I suppose it's because it's a compile error, and the top line (Private Sub, etc) is highlighted yellow.

I tried stepping over the code using F8, but it doesn't find anything wrong in that code.

[bobmaucher]

I expect what you meant was

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

YES, of course it's a parentheses issue. Thanks for the eagle-eye!