Sorry I don't know enough to explain this very well but I'll try. When I isolate the 3 different macros they work fine, it is just getting them all to play together nicely. I don't understand how to combine the 2 that start with: Private Sub Worksheet_Change. If I combine a "Private Sub Worksheet_Change" and a "Private Sub Worksheet_SelectionChange then I can get two of them to work.