VBA code to set page break to fill A4 sheet with no borders or margins

kelly mort

Well-known Member
Joined
Apr 10, 2017
Messages
1,932
Office Version
  1. 2016
Platform
  1. Windows
Hello,

I need a VBA code that when I run it, it will set a single page break for A4 sheet in such a way that the print area will cover the entire A4 sheet with no margin left.

I tried setting it up manually but could not get the right thing. I still have some small areas around and it's taking longer to complete.

If vba can do this please show me the way.

Thanks
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Trevor G

Well-known Member
Joined
Jul 17, 2008
Messages
6,704
Office Version
  1. 2016
Platform
  1. Windows
You can record a macro to give you what you want. Is your data filling the worksheet to a page break?
 

kelly mort

Well-known Member
Joined
Apr 10, 2017
Messages
1,932
Office Version
  1. 2016
Platform
  1. Windows
You can record a macro to give you what you want. Is your data filling the worksheet to a page break?

I thought of recording a macro but since I can't get it to fit manually, the recording will be a bit of another challenge for me to adjust.

Currently I am testing it with a blank sheet. I need to set the page so that I can bring an image to take up that space.
 

Watch MrExcel Video

Forum statistics

Threads
1,132,807
Messages
5,655,420
Members
418,198
Latest member
jad1984

We've detected that you are using an adblocker.

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.
Go back
Top