Somehow I can't edit my own post. I wanted to add, it is moot are you calculating new salaries using formulas or VBA - the problem is basic.