LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 208
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fitting columns on one page Sherry Excel Discussion (Misc queries) 6 May 1st 09 03:32 PM
Fitting date on the entire page. Rick Excel Discussion (Misc queries) 1 December 17th 08 09:56 PM
Why I get gray area in sheet tab of page setup? can't resize area. joey0617 Excel Discussion (Misc queries) 1 July 15th 06 05:30 PM
FITTING HEADER ON SECOND PAGE TO PRINT katenwoods Excel Worksheet Functions 0 September 8th 05 06:38 PM
fitting spreadsheet to page for printing Tim Excel Discussion (Misc queries) 1 January 13th 05 02:54 PM


All times are GMT +1. The time now is 12:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"