Hi
Have put together a small VB script from bits found on the net that I was hopeing would convert =now() to a format of YYYYMMDDHHMM, for now I've attached it to a button, but I'm not getting any result in the destination cell. Does anybody out there know how to fix it???
Sub Test()
Dim myDateTime As String
myDateTime = Year(Date) & Right("0" & Month(Date), 2) & Right("0" & Day(Date), 2) _
& Right("0" & Hour(Now), 2) & Right("0" & Minute(Now), 2) & Right("0" & Second(Now), 2)
myDateTime = Range("Q1").Select
End Sub
Thanks for reading
Bert