View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave D Dave D is offline
external usenet poster
 
Posts: 2
Default Macro: how to set a print area of varying size?

I need a macro to set the print area of a sheet that may vary greatly in the
number of rows - in Visual Basic, the macro seems to only accept this
instruction as a specific reference to a cell range. I cannot pre-format the
sheets or tel it to 'fit to' as again, the size varies so much that fitting
to 1x1 might render the sheet completely unintelligible.