Hi friends,
My data is in range 'b8:ae3000'
Column 't' birthdate, column 'ae' today's age
I want to run the macro 'AgeValue' after entering/changing the date in column 't'. At present I have inserted the call event in this workbook. As a result it runs each time I open the workbook. The birthdates in column 't' are not changing daily. It changes whenever I enter a new entry of contact but it is not daily. The AgeValue macro is running each time which I don't want. I want to save the time.

So I want to run the 'AgeValue' macro after entering/changing the date in column 't' only and not each time. Is it possible? If so please suggest me a code.

Thanking you in anticipation.

Regards,

Mukesh Baviskar