Fitting the used area to a page

  • Thread starter Thread starter Paul Robinson
  • Start date Start date
P

Paul Robinson

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
 
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.
 
Back
Top