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.

Brent E wrote:

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,

--

Dave Peterson