Help request to clear the data in column 'AO'

[mso3]

Hi friends,

If a date in column ‘AC’ is enter then I want to clear the entry in column ‘AO’ in that particular row only.
For ex. If I enter a date in column ‘AC’ cell address ‘AC6’ then I want to clear the data in column ‘AO’ cell address ‘AO6’ only.

I don’t want any action if the row is <= 5.

Please Login or Register  to view this content.

Any help will be highly appreciated.

Thanking you,

[Arkadi]

If I understand correctly then add this to your worksheet change event... either just after the first "with application" routine, or before the last one...

Please Login or Register  to view this content.

[mso3]

Perfect! Thank you.

Have a nice day.