center the content of a sheet before printing in VBA

[MrBaRRon]

Hi everybody,

I need to align at the center the content of an Excel sheet. (Forms control and cells). But the width of the content is not always the same.

I would like the code to center automatically before printing in VBA.

Thank U.

 

[PHV]

Something like this ?
ActiveSheet.PageSetup.CenterHorizontally = True

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244