Mother Macro again, the bain of a man's life...
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

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

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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 ****ed 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 ]

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com