Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing non-adjacent areas on seperate sheets in one print job
I've got a business modelling workbook that contains abt 25 worksheets, each with a large number (40) of "tables" on any single worksheet. What I've doen so far is automate (via VBA) the printing of "reports" where non-adjacent named ranges are created and then selected and printed. This gives me a single print job for each worksheet, with each table on it's own page.
However, the named ranges are giving me grief because of it 255 character limitation for the RefersTo property. I've done some playing with the Union function to group named ranges together temporaily for printing purposes, but have not been too successful. Does anyone know of a easier or more efficient way of accomplishing what I'm trying to do. I'm thinking something possibly with the Areas property, etc. Thanks Dan Knight |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
add two cells from seperate work sheets into a cell on seperate wo | Excel Worksheet Functions | |||
Can I adjust print scaling for multiple print areas on the same sh | Excel Discussion (Misc queries) | |||
Excel 2003 - How to print areas in separate sheets to 1 pdf file | Excel Discussion (Misc queries) | |||
how do I print seperate excel tab sheets in duplex | Excel Discussion (Misc queries) | |||
How do I set print areas for multiple sheets simultaneously? | Excel Discussion (Misc queries) |