Excel 2004
I'm trying to set the print area of a spreadsheet with VBA. I can get it
to make the selection, and what I've found for setting the print area
(not being to VBA aware) is: ActiveSheet.PageSetup.PrintArea = Selection
However, though this selects the range I want, the print area is still
the entire spreadsheet.
If I use Selection.PrintPreview I get just the selection, and can print
the selection I want from here, but I don't get access to the print
dialogue box, which I need to set certain printer options.
Any suggestions?
Is this question more suited to a different Excel group? If so, and you
can suggest one, I'd be grateful for the pointer.
Thank you for any help you can give.
Justin
--
Justin C, by the sea.
|
