copy it as written into 'thisworkbook' section
(without the dashes lol)

its an event macro because it triggers on an event - in this case
worksheet_change so every time that event happens this code will run,

it checks if anything in column c changed (intersect(target,[C:C]) is
nothing) and if it has clear columns(5) (which is e)

"Dan Wood" wrote:

How does this work? How do i make it as an event macro?