|I am confused as to where you want the date on Sheet(1). So here is the code I would have used:|
Add this to what you have at the top of your code:
Dim nowdate As Date
nowdate = DateValue(Now)
Now you can use 'nowdate' wherever you'd like. For example, to test the code, I just had it pop up in a message box.
MsgBox("Today's Date Test: " & nowdate)
Hope this helps.
Law of Logical Argument: Anything is possible if you don't know what you're talking about.
message edited by Newbie10