VBA Auto Center Worksheet Contents

[Bench]

Hi,

Just wondering if there is a way to center a worksheets contents, for example i have a table that covers B2:F9 so when it prints off it shows as you would expect in the top left corner.

Obviously you can drag the borders and guestimate when you have the table in the center of the worksheet, is there a more accurate way to do this? or some script that could do this. i guess it would involve selecting a range and then doing some kind of autofit....

To clarify i would want the table to show bang in the middle, so equal distance from top and bottom AND equal distance from left border and right border.

Any ideas?

Thanks

Ben

 

[Andrew Poulsom]

In Page Setup on the Margins tab there are checkboxes to Center on page Horizontally and Vertically.

 

[Bench]

thank you kindly