Auto Update the date.

Nirik · #9 12-14-2010, 09:14 PM

As per suggestion i have recorded the macro again, but still having problem with the macro. below is the macro
Sub Macro1()
'
' Macro1 Macro
'
' Keyboard Shortcut: Ctrl+y
'
Range("K8").Select
ActiveCell.FormulaR1C1 = "YES"
Range("M8").Select
ActiveCell.FormulaR1C1 = "=TODAY()"
Range("M8").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date auto-populates based on checkbox	mcarter9000	Word VBA	5	12-23-2010 12:39 PM
Creating an Auto-Calc'd Date? Today+7 Days?	SoCalTelephone	Word	0	10-06-2010 10:27 AM
Project Auto-Update	hB-sys	Project	0	04-15-2010 06:46 AM
Auto date alarm?	markg2	Excel	3	11-18-2009 08:25 AM
new appointment date always reverts back to today's date	msills	Outlook	0	08-24-2007 08:57 AM