Printing Macro

Mar 13th, 2002, 03:23 AM

I need a macro that will print (the range of cells from A1-F52 ) the sheets called 'Invoice'

Dave Hawley · Mar 13th, 2002, 03:44 AM

Hi

You could use:

Sub PrintIt()
Sheets("Invoice").Range("A1:F52").PrintOut
End sub

but you might be better off Recording a macro so you get your page set up setting. Or you could look at "Report Mangager" in the Excel help.

_________________
Kind Regards
Dave Hawley
OzGrid Business Applications
Microsoft Excel/VBA Training

[ This Message was edited by: Dave Hawley on 2002-03-13 02:44 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 03:23 AM	#1
Guest Posts: n/a	I need a macro that will print (the range of cells from A1-F52 ) the sheets called 'Invoice'

Mar 13th, 2002, 03:44 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi You could use: Sub PrintIt() Sheets("Invoice").Range("A1:F52").PrintOut End sub but you might be better off Recording a macro so you get your page set up setting. Or you could look at "Report Mangager" in the Excel help. _________________ Kind Regards Dave Hawley OzGrid Business Applications Microsoft Excel/VBA Training [ This Message was edited by: Dave Hawley on 2002-03-13 02:44 ]