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
|