How do i avoid printing blank rows in a selected range of cells using VB
script.
Application.Goto Reference:="Zone1"
ActiveSheet.PageSetup.PrintArea = "Zone1"

I've got a multiple spreadsheet layout that I want to print. After setting
the print area on sheet 1, the default area selected was down to line 56. On
following sheets after setting the print area the default area selected only
reaches row 52. All specs on all sheets are identical. ...