On Mon, 31 Jul 2006 22:15:32 -0400, scottnshelly
wrote:


The problem is, I don't always know which time zone a user is in. Are
there any solutions that don't require previous knowledge of the user's
time zone?

I'm currently using:
ActiveCell.Value = Format(Date, "mm/dd/yyyy")
ActiveCell.Offset(0, 1).Select
ActiveCell.Value = Format(Time, "HH:mm:ss")


Thanks.

If you cannot determine the user's time zone, I don't see how you can format a
cell referencing referencing his time zone.
--ron