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