iluvtorrent,
Mud's code (link in his post above) provides a nice way of doing it, but for a 'quick-and-dirty' method like my SendKeys post, you could use:
To enter just the current date.
Even in the Excel worksheet you can do this, you don't need code unless you want to automate it:
In any cell, press CTRL + ; (CTRL+SEMI-COLON) and it will insert today's date as static (won't change if you open the sheet tomorrow)
and in any cell, press CTRL + SHIFT + ; (CTRL+SHIFT+SEMI-COLON) and it will insert the current time as static.
Mud - thanks for the follow-up.
Bookmarks