Excel - Enter Last Modified date into a cell

May 29, 2009 at 13:22:03
Specs: Macintosh
I have been looking around for an Excel VB Macro or formula that will enter the date into a cell when any cells on the ROW have been modified.

I am running Excel 2008 for Mac

I have multiple columns (A through S), where some already contain data. I want to have the date automatically appear in column T when any of the cells (A-S) have been modified. I have many hundreds of rows.

I am new to Macros but am very versed in formulas.

Thank you for any assistance anyone can offer.

See More: Excel - Enter Last Modified date into a cell

Report •

May 29, 2009 at 20:44:08
I don't use a Mac and I'm running Excel 2003 Pro, so this is what I would do:

Right-click the sheet tab, choose View Code and paste this in:

Private Sub Worksheet_Change(ByVal Target As Range)
  Range("T" & Target.Row) = Date
End Sub

Is that how you enter a Worksheet_Change macro in Excel 2008?

Report •
Related Solutions

Ask Question