Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Individual Page Selection
HOWDY! The following lines copies the entire print range for the activeworksheet: Dim wks as Worksheet wks.Range(wks.PageSetup.PrintArea).Copy How can I alter this so that it will select the individual pages inside the selected print range instead of the ENTIRE print area? Thanks. - Chris -- Chris Shaw ------------------------------------------------------------------------ Chris Shaw's Profile: http://www.excelforum.com/member.php...o&userid=25041 View this thread: http://www.excelforum.com/showthread...hreadid=386214 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Individual Page Selection
Hi Chris
You must loop throught the pagebreaks Maybe this example to copy each page in new sheet will help you http://www.rondebruin.nl/hpagebreaks.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Chris Shaw" wrote in message ... HOWDY! The following lines copies the entire print range for the activeworksheet: Dim wks as Worksheet wks.Range(wks.PageSetup.PrintArea).Copy How can I alter this so that it will select the individual pages inside the selected print range instead of the ENTIRE print area? Thanks. - Chris -- Chris Shaw ------------------------------------------------------------------------ Chris Shaw's Profile: http://www.excelforum.com/member.php...o&userid=25041 View this thread: http://www.excelforum.com/showthread...hreadid=386214 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fit to one page selection creates one page for each cell | Excel Discussion (Misc queries) | |||
How do I save an individual page in a workbook? | Excel Worksheet Functions | |||
Individual cell selection in a range | Excel Discussion (Misc queries) | |||
How do I get my page selection to print on one page? | Excel Discussion (Misc queries) | |||
Moving page up and down with arrow keys instead of individual cel. | Excel Discussion (Misc queries) |