View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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 ....