Help with VBA – Assign a current date

Topic

New Reply

Hi,

Part of of the VBA code that I have is to set up a formated current date in G2. The code that I have is:

Range(“G2”) = “=now()”
Range(“G2”).NumberFormat = “d-mmm-yyyy, h:mm AM/PM”
Range(“G2”).Value = Range(“G2”)

This works, but I’m sure there is a better way to do this and in a single line of code. Can anyone help me figure it out?

Reply | Quote

Replies

You can shorten it to two lines. I don’t think it’s possible to do it in one command since you are performing two operations. One being adding the date, the second being the formatting of the date.

Range(“G2”) = Now()
Range(“G2”).NumberFormat = “d-mmm-yyyy, h:mm AM/PM”

Reply | Quote