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 ....
|