Hi
You could attach Catalin's code to the Worksheet rather than a module using the Worksheet_Change event. That way as soon as you change a cell the code will run automatically each time a change is made.
Hope this helps.
Tony