I've been trying to automate printing a range of a spread sheet in Excel 2003 and am finding the process very awkward. Are later editions of Excel easier to print from?
Never mind. Just realized I can use range names for the print area and have the print macro re-size the print area to suit.
Will probably be asking some dumb questions about page breaks in the near future.
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 Recording". Review your code and then you know how to do what you need to do.