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

[kelly mort]

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

 

[Trevor G]

You can record a macro to give you what you want. Is your data filling the worksheet to a page break?

 

[kelly mort]

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.