how to set print area within macro

ap2 · Apr 5th, 2002, 08:35 AM

For a varying size of report how to set print area within macro ?

Larry · Apr 5th, 2002, 12:43 PM

Try this...You will first need to define the name of your data range.

rowcount = Range("Output").Rows.Count

Sheets("Report").Select
printrange = "A1:K" & rowcount
Sheets("Report").PageSetup.printarea = printrange

[ This Message was edited by: larry on 2002-04-05 13:31 ]

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

Apr 5th, 2002, 08:35 AM	#1
ap2 New Member Join Date: Mar 2002 Posts: 3	For a varying size of report how to set print area within macro ?

Apr 5th, 2002, 12:43 PM	#2
Larry New Member Join Date: Apr 2002 Location: Plano, Texas Posts: 29	Try this...You will first need to define the name of your data range. rowcount = Range("Output").Rows.Count Sheets("Report").Select printrange = "A1:K" & rowcount Sheets("Report").PageSetup.printarea = printrange [ This Message was edited by: larry on 2002-04-05 13:31 ]