Print Macro

  • Thread starter Thread starter MWS
  • Start date Start date
M

MWS

I'm trying to write a print macro that adjusts to the
everchanging size of the file in which I'm trying to print
(ie on one occassion the print data might be in A1:C40 and
the next time A1:E100). Can anyone help me in writing the
print macro so it automatically adjusts to the proper
print area size?

Thank You for the Consideration!
 
ActiveSheet.Printout (if printarea is not set)

usually adjusts unless you usedrange does not reflect your actual usage.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
Auto Detect Data, Auto Print Data, Auto Erase Data Loop 8
Macro for printing 2
Macro for Print Area 1
Macro to control Print area/view 2
Laserjet 6L print density adjustment 0
Macro Adjust Based on Dataset? 1
Macro Print Range Problem - Rows Cut Off (Upgraded From Excel 2003 to2007) 1

Back
Top