View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
spreadsheetlady spreadsheetlady is offline
external usenet poster
 
Posts: 11
Default Date does not update until worksheet change

Hi,
My work sheet has a date in cell: "A1".

I would like the date to update (only) if there is a change in the sheet.

I'm thinking of this to start:
Something like Private Sub Workbook_SheetChange(By Val Sh As Object, By Val_
Target As Excel.Range)

Thanks in advance,
Amy