Compile Error: Wrong arguments or Invalid property

B

Brent E

Excel 2003; Windows XP SP2

Good day,

I am working on some VBA subs and I keep getting a error when I try to run a
sub that tries to select a range of cells

I see:

"Compile Error.

Wrong number of arguments or Invalid property assignment."

I even tried just a really basic macro and having Excel record the macro and
do the code for me. I pressed record, and then selected a range of cells in a
single column and then pressed stop recording.

I looked at the code and this is the code that was written:
Range("M2:M20").Select

I try to run this macro and I get the same error.

Any ideas?

Please advise.

Thanks,
 
D

Dave Peterson

Have you been playing with user defined functions?

Any chance you created a UDF named Range?

If you did, then change its name to something else and test your code once more.
 
D

DaveO

Is that the line that's highlighted when the compiler errors out? That
line looks valid to me. I wonder if the "wrong number of arguments" is
occuring on another line of code- simply putting a different range in
causes that other line to error out.
 
B

Brent E

Thanks to you both for your responses.

I've not been been using any user defined functions or UDF named Range to my
knowledge, what would be an example of such?

In regard to second question, that was the only line of code in the test
macro but still gave me an error. Not sure why? I haven't had time to retest
them this morning. I tried closing the program and reopening, but no
difference. I will try rebooting and see if that makes any difference.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top