Getting a VBA-Created Date to Format Correctly

[Cyberdude]

I am using VBA to create a new sheet, then populate it with data. As an afterthought, I decided to add a revision date:

Range("A1") = Format(Date,"mmm d, yy")

Well, it writes the date, but the format is 13-Apr-05.
I know I can go into Excel and format it correctly, but why doesn't the VBA Format function do it for me??

[Jacob Hilderbrand]

Well, you are just putting the value in the cell. Regardless of the format you enter it as, it will still be formatted based on the cell's specific formatting.

Range("A1") = Date
    Range("A1").NumberFormat = "mmm d, yy"

[Cyberdude]

Thanx, DRJ ... I knew I was missing something.

[Jacob Hilderbrand]

You're Welcome

Take Care