Date change

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

Would this be one correct way of adding code to the
workbook if you wanted the date to change everytime the
workbook changed.
Workbook_SheetChange
Range("G2").Value = Date
Do I need the .Value?
 
Would this be one correct way of adding code to the
workbook if you wanted the date to change everytime the
workbook changed.
Workbook_SheetChange
Range("G2").Value = Date
Do I need the .Value?

Not really; in this particular case it'll make no difference.

However you may want to qualify the Range reference with a sheet name,
otherwise you'll just be plastering that date into cell G2 of the
current sheet (whichever sheet that may be). If you want to keep a
record of when the workBOOK changed (as opposed to any particular
worksheet), I'd have thought that you'd want it in one central
location. (Otherwise you'd have to thumb through each sheet looking
for the latest date.)
 
Back
Top