I am trying to use different page setups but I get object errors. What is the proper way to use the page setup arguments?
Sub Print_DB()
Dim db As Worksheet
With db
.PageSetup.FitToPagesWide
.PageSetup.PaperSize = xlPaperLetter
.PageSetup.Orientation...
Hi gang,
I am working with some code that sets print formats for a summary page and I am encountering the strangest thing.
Issue
Whenever I run the code on files that contain filenames that have numbers in them (example: 300 Racks) the .PageSetup.CenterHeader code that I have gets...
Hi there,
I have 10 pages in my workbook - made up of 5 tabs each with 2 pages
When I select all tabs and go to print, they sequentially number 1 - 10 (I have set up a Footer with "Page &[Page]" to do this)
I want the first page to be number 7 - so change the First Page Number from 'Auto' to...
I have a workbook currently with 1 worksheet in - it has a macro that creates a series of new sheets and what I would like is to have the page set up copied from the sheet currently called sheet1 to all the new sheets (could be any number up to 20 created depending on what data is on sheet 1)
I...
Not sure if this is possible, but figured I'd check here just in case. I have a sheet that has 3 different pages on the same tab, and I'd like to be able to set the print layout/setup of each page in the sheet separately. More specifically, I want to print the first two pages at PageSetup.Zoom...
I currently have a workbook template that is setup with two tabs and is used to create a file for each day of the week. One tab is oriented in portrait (fit to page), the other is oriented in landscape (fit to page). There is a macro to print the workbook. The problem I have is that it uses...
Hello, please I have a problem with adding more lines into footer using pagesetupfooter. Does onyone know what special character can I use for new line in footer text?
ActiveSheet.PageSetup.LeftFooter='Text in First line'+'\N '+'Text In Second Line'
But \N does not work.
Any Ideas?
Thanks a...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.