Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Print problem for worksheet selection 1

Status
Not open for further replies.

UnsolvedCoding

Technical User
Jul 20, 2011
424
US
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.
 
On the very few occasions I have needed to something like this I have used code along the lines of
Code:
ActiveSheet.PageSetup.PrintArea = Range(Cells(1, 1), Cells(LastUsedRow, LastUsedCol)).Address
 
HI,

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

Generally, you could set a print area...
Code:
Worksheets("Sheet1").PageSetup.PrintArea = "$A$1:$C$5"

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top