LonnieP,
It seems that you are new to Excel VBA programming, so the best tip is to use the "Record Macro" function found in the Developer menu or Developer tab. Click "Record Macro", change the color of a cell, print, insert a row, copy and paste, or any other activity and then click "Stop...