Error message: Compile error: Wrong number of arguments or invalid property assignment

[Snoopy]

Hey guys
I'm turning really mad at Excel VBa. Some days work with recording etc
seems to be a waste.....
The debugger stops one of my many, but very tiny, little macros at this

point:
Range("A7").Select

... and presents this &%&&!!¤¤ error-message (sorry for the language -

but I'm frustrated):


Error message:
Compile error:
Wrong number of arguments or invalid property assignment


The same error occurs in every step that use range.select commands


I have no clue how to fix this in the macro that until recently run
well.
I hope for Your help.


Regards
Snoopy

 

[Dave Peterson]

Just a complete guess...

Do you have a function or a subroutine called Range in your procedure?

I could get weird errors when I did--they didn't match your message, but maybe I
just didn't test it the same way as you have.