Heh, I found the error shortly after posting this. It's what you said, Andy.
I had a subroutine named Format. I felt pretty dumb after I found it. :)
"Andy Pope" wrote:
Hi,
It's possible there is a Subroutine or Function with the same name as a
built in one but with different arguments or return variable.
Cheers
Andy
Chad wrote:
I have two add-ins that I created for excel 2000. Each add-in uses the
format function to reformat dates, etc. The module from add-in #1 is now
giving me this error:
"Wrong number of arguments or invalid property assignment."
Here is my code that I am running on each module:
sub test()
msgbox format(cdate(date),"mm-dddd-yy")
end sub
(the actual code I'm running is obviously more involved, this is just a test
macro)
On the module for add-in #2 it runs fine, on the other I recieve the error
message. I'm sure it's a simple thing I've overlooked but I'm unable to find
it. I clicked on "Tools" and "References" and they both have the same
references checked off. I'm at a loss.
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info