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