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

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

..=2E and presents this &%&&!!=A4=A4 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.=20
I hope for Your help.=20


Regards=20
Snoopy

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.

Snoopy wrote:
>
> 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