DO NOT USE RESERVED WORDS AS PROCEDURE OR VARIABLE NAMES!!! ('shouting'
intended <g)

On Mon, 4 Oct 2004 15:26:30 -0500, jordanctc
wrote:


Tom,

***I got it to do it again - This worked

Sub Trial1()
Range("A1").Value = Format(Now(), "m-dd-yyyy")
End Sub

***Then I added a macro named Format - this gave me the compile error
when trying to run Trial1

Sub Trial1()
Range("A1").Value = Format(Now(), "m-dd-yyyy")
End Sub

Sub Format()
MsgBox "Now I'm messing with you"
End Sub

***Then I renamed Format to Format1 - this ran fine

Sub Trial1()
Range("A1").Value = Format(Now(), "m-dd-yyyy")
End Sub


Sub Format1()
MsgBox "Now I'm messing with you"
End Sub

And I might not have been clear but all computers were getting the
error today until I changed the macro name. Another behavior I noticed
was when there was a macro named Format, when typing in "format(" the
property popup did not show.

Jordan