A simple sendkeys command may do the trick.

Sub Macro1()
' use with the range statement to specify a location or without to place the
value in
'the activecell
Range("B25").Select

SendKeys "^{;}"

End Sub

hth

DMoney
--
EzMoney


"PrologPro" wrote:

I'm trying to come up with the quickest way to enter the current date and
time in my spreadsheet.

So far here's what I've tried:

Macro which recorded CTRL + ; (space) CRTL + SHIFT + ;
Unfortunately if you look at how the macro recorded this static date, it
actually has today's date listed in VB, not the actual function. I just want
VB to perform the FUNCTION.

I also tried the NOW() function, but I will have multiple rows keep track of
patches I've applied, and the date and time will change with each row entry.
The NOW formula updates all rows with the same date and time.

Any suggestions would be greatly appreciated.
Thanks!