Thu 12 Aug 2010, 16:36Delegate Eoin said...
Eoin has attended:
Excel VBA Intro Intermediate course
VBA code for printing documents
I would like to add some code at the end of a macro to print the excel page(s) I'm working on, could you please let me know how I do this?
Sun 15 Aug 2010, 01:37Trainer Anthony said...
RE: VBA code for printing documents
Hi Eoin, thanks for your query. The simplest way to get the code to do this is to record a macro of you printing the spreadsheet. Try this code at the end of your subroutine, it should print out the active worksheet:
ActiveWindow.SelectedSheets.PrintOut Copies:=1
Hope this helps,
Anthony
