I have the following in a VBA add-in:

Rows(1).Insert
Range("A1").Value = "H"
Range("B1").Value = MemoNumber
Range("C1").Value = Date
Range("C1").NumberFormat = "m/d/yyyy"
Range("C1").NumberFormat = "@"

I use the last three lines to obtain a date in the format m/d/yyyy for
input to another process. Problem is, this doesn't always
work. I use the exact same code in various places in the
add-in. Sometimes it works, sometimes I don't get the format
I expect. I have just inserted the row - shouldn't this work
the same every time?

Kevin

--
Message posted via http://www.officekb.com