Mother Macro again, the bain of a man's life...

[Audiojoe]

You know those days when you feel so lucky about everything and it's all going well until you have to create a macro to print today's date. It's sounds so easy doesnt it, but I am damned if I can find the way to do it.

All I need to happen is for every time I press the button with the macro assigned, the active cell shows today's date, and if possible the time as well. Can anyone help with this?

I feel unlucky as hell now. My house has probably burned down whilst I've been here at work, and I keep stepping on cracks. I'm just waiting for the black cat to stroll out in front of me...
This message was edited by Audiojoe on 2002-02-21 07:14

 

[Juan Pablo González]

Sub DateTime()
Range("A1") = Now
End Sub

 

[Audiojoe]

Thanks man, you really are the mutt's nuts at this racket