View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jakester Jakester is offline
external usenet poster
 
Posts: 1
Default Simple change event. Need guidance.

I want to run a simple If..Then based on a change to a range of cell
containing text. Basically something like this

If Range("E50:E100") changes Then
Range("A3") = Now()
End if

So if the text changes in the range the date of the document updates t
the system date. Seems like it should be simple but I can't figure ou
how to do it. Any help appreciated.

Jakeste

--
Message posted from http://www.ExcelForum.com