View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fatwilly Fatwilly is offline
external usenet poster
 
Posts: 3
Default Timestamp for changes in any row of cells?

Hi,
I am trying to set up a timestamp at the end of a row of cells that will
enter the current date if any cell in the row is altered or updated. I can
only do it at present with one cell, if I use a range of cells the formula
doesn't work, not sure why. The formula I use is
=IF(R4="","",IF(T4="",NOW(),T4)) If I change the R4 to A4:R4 I get a wrong
#Value.
I'm running Office Pro Excel 2003 edition with SP3.

Thanks for any help.