General discussion
August 27, 2007 at 12:42 PM
jeff

Excel: Auto Date Stamp

by jeff . Updated 19 years, 2 months ago

I have an excel spreadsheet that I would like to have cell A1 updated any time a change is made to cells A5:G116. I have played around with mutiple statments but each time I receive and error. In all honesty I am not a skilled VB writer, but I am learning day to day. So far I have:

Private Sub Worksheet_Change(ByVal Target As Range)
If Range(“A5:G116”) Is Nothing Then Exit Sub

What do I need next to return the results to cell A1?

This discussion is locked

All Comments