View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Robinson Paul Robinson is offline
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