This would handle any new sheets.It works on ANY sheet not called "Macro".So if there is two sheets or two hundred (which I think is doubtful)it would cycle through each one.(for I = 1 to sheets.count)