Excel - Visual Basic for Preview and Printing
Environment
Code
- Microsoft Excel 2003 / 2007
Code
'Preivew
Private Sub previewPage(whichPage As String, printRange As String)
Sheets(whichPage).Select
Range(printRange).Select
ActiveSheet.PageSetup.PrintArea = Selection.Address
Application.Dialogs(xlDialogPrintPreview).Show
Sheets(whichPage).Activate
End Sub
'Printing
Private Sub printPage(whichPage As String, printRange As String)
Sheets(whichPage).Select
Range(printRange).Select
ActiveSheet.PageSetup.PrintArea = Selection.Address
Application.Dialogs(xlDialogPrint).Show
Sheets(whichPage).Activate
End Sub