Print problem for worksheet selection 1

[UnsolvedCoding]

I am trying to set up a page so that when it is printed the print area is preset.

So far I have found ways to print the selection and toyed with Workbook_BeforePrint, but have not found a way to preset the selection area for the user. Given the amount of printing, setting the print area is going to be a huge time impact.

Does anyone know how to do this?

It has taken me a while to make sense of what I hear at work involving computers. There is much talk of bugs and questions about Raid.
Therefore I have come to the logical conclusion that the only way to have a properly functioning computer is to regularly spray it with Raid bug killer.

 

[Deniall]

On the very few occasions I have needed to something like this I have used code along the lines of

ActiveSheet.PageSetup.PrintArea = Range(Cells(1, 1), Cells(LastUsedRow, LastUsedCol)).Address

 

[SkipVought]

HI,

It's not clear exactly what you have tried that has not worked.

Generally, you could set a print area...

Worksheets("Sheet1").PageSetup.PrintArea = "$A$1:$C$5"

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[UnsolvedCoding]

Thanks to both of you.

Skip that gave me what I needed.

It has taken me a while to make sense of what I hear at work involving computers. There is much talk of bugs and questions about Raid.
Therefore I have come to the logical conclusion that the only way to have a properly functioning computer is to regularly spray it with Raid bug killer.