View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark A. Sam Mark A. Sam is offline
external usenet poster
 
Posts: 10
Default Refreshing one cell

Hello,

I'm not too proficient with Excel so hopefully this can be done. My client
is using this formula to update the date and time in a particular cell:

=IF(A2="","",NOW())

He wants it to update only when A2 is updated, but it updates when any cell
is updated. Does this require a code and if so how to implement it.

Thank you for any help and God Bless,

Mark A. Sam