Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple print areas
The below piece of VB prints out a print area on my worksheet OK where the print area varies in length. Sub Button4_Click() cc = 26 For r = 26 To 150 If Sheets("Moves Request Form").Range("AF" & r) = "CC Reference Number :-" Then cc = r Next r Sheet1.PageSetup.PrintArea = "B3:CP" & cc 'Sets the Print area ActiveSheet.PrintOut 'Prints the Print area Sheet1.PageSetup.PrintArea = "" 'Clears the Print area End Sub There is always a piece of data in the middle somewhere that I dont need to appear on the printout. Is there any way I can include two different print areas in the above VB? -- grahammal ------------------------------------------------------------------------ grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336 View this thread: http://www.excelforum.com/showthread...hreadid=517229 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I print multiple print areas on one page | Excel Discussion (Misc queries) | |||
Can I adjust print scaling for multiple print areas on the same sh | Excel Discussion (Misc queries) | |||
printing multiple print areas with a print dialog box | Excel Programming | |||
Set Multiple Print Areas | Excel Discussion (Misc queries) | |||
Multiple print areas, one worksheet -need to print to PDF! | Excel Programming |