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

S

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
 
D

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.
 

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

Similar Threads

Compile Error: Wrong arguments or Invalid property 3
new ReportToPDF 8
ReportToPDF 1
XNPV in VBA 2
XNPV Function 1
unload Me compile error 2
Wrong number of arguments 1
Compile error in Excel 1

Top