I can get as far as bringing up the print preview screen using VBA. How do I then get VBA to squeeze my spreadsheet onto one page before printing. There is probably a simple solution out there but I'm currently teaching myself VBA by trial and error... but my boss seems to think I know what I'm doing!!!
Page Setup in Excel 2003 using VBA
Hot Topic
- paste into next blank column
- Dynamicaly enter Data in Microsoft Access
- Adding data in one column based on another column using VBA
- Write text from a list box to a table in MS Access 2003 (VBA)
- cutting down this code? help?
- Office Communicator 2005 sign-in name, auto populate after install somehow?
- Sorry it may not have been clear as>>
- How to stop a never ending loop
- Programming Adobe Acrobat Reader 7.0
- VBA Excel - Using The "For each" function with a string
Microsoft ISV
- recuring compilation errors after access 2.0 conversion to access 97. Please HELP!!!!
- Load userform returning variable not defined error (91)
- Can you use VBA to access a spread sheet embedded in a word doc?
- MS CRM 3 and outlook
- access populate combo box help needed
- BSM 2005 server installation failed
- VBA - Create View
- VBA for Powerpoint
- Copying formulas From a Range of cells
- Reading PDF files from VBA
Page Setup in Excel 2003 using VBA
kinpin9
Assuming all the data you want to print on a single page exists on Sheet1:
Sheet1.PageSetup.Zoom = False
Sheet1.PageSetup.FitToPagesTall = 1
Sheet1.PageSetup.FitToPagesWide = 1
That should do it. (I won't tell your boss if you don't!)