Printing

How do I print in Excel using VBa only the cells that contain data?

Steve

Use this:

Worksheets("Sheet1").PageSetup.PrintArea = "$A$1:$C$5"
Worksheets("Sheet1").Printout