Hi:

I'm trying to program a macro to "Print" button on a worksheet which prints each report generated by specific criteria. This print area should start at a specific cell ( always A13) to the last row of each specific report generated.

What is the best way to do this by macro attached to the button.

The macro I have now basically prints all of the active sheet which includes the unwanted top rows of the page (which I am trying to elimate), ie:

Sub PrintSalesReport()
'
' PrintSalesReport Macro
'
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End Sub


But I want it to start at cell A13 to eliminate unnecessary rows of data above that cell, and to include all data on that page to the last row of data, which changes with each report generated by the specified criteria ie: dates, salesperson, etc

How can I be more specific in my macro which is attached to the "PRINT" button I have created.

Thanks for any help given.

Jean