Excel VBA-Error, range function not working?!?!?
 

I have been perfecting several macros and all of the sudden I recieve
the following error


Compile Error:

Wrong number of arguments or invalid property assignment


The error highlights the word "range", of all things! This has never
happened and I have no idea how to rectify the situation. Any help
would be much appreciated...

Ryan


---
Message posted from http://www.ExcelForum.com/

Excel VBA-Error, range function not working?!?!?
 

Did you put in a sub or function that uses Range as the function/sub name?

--
Regards,
Tom Ogilvy

"waveracerr " wrote in message
...
I have been perfecting several macros and all of the sudden I recieve
the following error


Compile Error:

Wrong number of arguments or invalid property assignment


The error highlights the word "range", of all things! This has never
happened and I have no idea how to rectify the situation. Any help
would be much appreciated...

Ryan


---
Message posted from http://www.ExcelForum.com/

Excel VBA-Error, range function not working?!?!?
 

I bow to your knowledge, Fridays DO lend themselves to petty mistakes
suppose....

--
Message posted from http://www.ExcelForum.com