| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fitting the used area to a page
Hi,
Does anyone have a reliable sub for taking a UsedRange and fitting it to a single A4 page (so that the column widths and row heights are rescaled seperately and the UsedRange fills up the page)? I reckon somebody must have done this, including LandScape versus Portrait cases! regards Paul |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Fitting the used area to a page
I doubt anyone has done this. Perhaps you could take a picture of the
userange, then put the picture on another worksheet and scale the picture to achieve the effect you want. -- Regards, Tom Ogilvy "Paul Robinson" wrote in message om... Hi, Does anyone have a reliable sub for taking a UsedRange and fitting it to a single A4 page (so that the column widths and row heights are rescaled seperately and the UsedRange fills up the page)? I reckon somebody must have done this, including LandScape versus Portrait cases! regards Paul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fitting columns on one page | Excel Discussion (Misc queries) | |||
| Fitting date on the entire page. | Excel Discussion (Misc queries) | |||
| Why I get gray area in sheet tab of page setup? can't resize area. | Excel Discussion (Misc queries) | |||
| FITTING HEADER ON SECOND PAGE TO PRINT | Excel Worksheet Functions | |||
| fitting spreadsheet to page for printing | Excel Discussion (Misc queries) | |||
Linear Mode
