| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a limit on the length of a PrintArea?
Hi,
I have a worksheet that can contain anywhere from 22 to 40 embedded charts. I am trying to create code that sets non contiguous <sp print ranges so that each chart will print on it's own page. Each chart is 51R x 22C. When the length of the print range string I've built exceeds 255 characters I get a RT 1004 error "Unable to set the PrintArea property....". Does anyone know of a way around this limitation or suggest an alternative way to accomplish the task? -- TIA Chuck M. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Criteria length limit in SUMIF() | Excel Worksheet Functions | |||
| setting a cell length limit | Excel Discussion (Misc queries) | |||
| Text length limit | Charts and Charting in Excel | |||
| number length limit | Excel Programming | |||
| Limit text length with inputBox | Excel Programming | |||
Threaded Mode
