View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GregR GregR is offline
external usenet poster
 
Posts: 246
Default Change Event on a named range

I have a worksheet with a named range of invoices (Range(A5:X500)). If
anything changes in this range, I want the corresponding cell in the
active row, column(AC) to add today's date and then an event if the
sheet is saved to convert today() to the value of today. Help
appreciated. TIA

Greg