APPLICATION.RANGE EXCEL
 

Microsoft XP Windows 2000

Have many macros using Range("B2") etc.

Of a sudden none of my macros will run giving me a wrong number of arguments
error. I am having to change put Application. infront of Range("B2")
Application.Range("B2")

Why would this quite taking Range("B2") without application in front?

Have many, many macros with many, many range("xx") lines in it .....

Any explanation?

Thanks in advance ....

APPLICATION.RANGE EXCEL
 

More than likely
You have written code (a procedure) that has the name RANGE or you have
defined a variable with the Name RANGE.

You need to change the name.

--
Regards,
Tom Ogilvy


"FGM" wrote in message
...
Microsoft XP Windows 2000

Have many macros using Range("B2") etc.

Of a sudden none of my macros will run giving me a wrong number of
arguments
error. I am having to change put Application. infront of Range("B2")
Application.Range("B2")

Why would this quite taking Range("B2") without application in front?

Have many, many macros with many, many range("xx") lines in it .....

Any explanation?

Thanks in advance ....

APPLICATION.RANGE EXCEL
 

Thank you... I came back here to say I found it and here was your answer...
that was just what it was. I went through all the new macros one at a time
pasting them back in after cutting them out...


"FGM" wrote:

Microsoft XP Windows 2000

Have many macros using Range("B2") etc.

Of a sudden none of my macros will run giving me a wrong number of arguments
error. I am having to change put Application. infront of Range("B2")
Application.Range("B2")

Why would this quite taking Range("B2") without application in front?

Have many, many macros with many, many range("xx") lines in it .....

Any explanation?

Thanks in advance ....