Thanks Bob, I'll do that. Having to execute a macro manually would defeat the object, but if there is a way that VBA can recognise when a value (any value) is entered into a cell and self-execute, then yes, that would be a happy answer.