The code was so long, I was reluctant to foist on others to pore over.

I just found the problem. It's embarassing, but I need to fess up anyway.
Way down in the code I had set up a subroutine and named it "Format."
Another lesson learned.

--
Ken Hudson


"Rick Rothstein" wrote:

Why not post your code and get many eyes looking for your problem?

--
Rick (MVP - Excel)


"Ken Hudson" wrote in message
...
Mike and Rick,
Thanks for the replies. I commented out all the other code in the macro
and
I can get it to work. (I do have to use a string variable for the date.)

I guess I'll go back through the code and un-comment sections until I find
the culprit.
--
Ken Hudson


"Ken Hudson" wrote:

I have the following code as part of a macro:

Dim strTest As String
strTest = Date
strTest = Format(strTest, "mm-dd-yy")

When I compile the code I get the following error:

Compile error:

Wrong number of arguments or invalid property assignment.

I am getting a headache staring at this and trying to figure out the
obvious
error, but can't.


--
Ken Hudson