You have three options:

- make the "SENT" message appear in the next door cell
- use conditional formatting to indicate it is sent
- write a macro that runs down the column replacing the value in the cells with "SENT"
_________________________
Remind me to change my signature to something more interesting someday