View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
DDub207 via OfficeKB.com DDub207 via OfficeKB.com is offline
external usenet poster
 
Posts: 6
Default Add date to cell with open macro

Thanks... It works.

Vergel Adriano wrote:
Duane,

To put the current date in M3:

Range("m3").Value = Date

This should have been easy for me to figure out but I couldn't do it. I'm
just trying to have a cell auto-populate with the current date. I can't use

[quoted text clipped - 6 lines]
Range("m3").Value = Range("m3").Value + 1
End Sub


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200708/1