Macro (Center text)

[PRodgers]

I have a macro that output a month based upon a date that has been entered in a row on my spreadsheet. I want the macro to center the text but im not sure of the syntax, the macro code is below:

Please Login or Register  to view this content.

Can anyone help

[DonkeyOte]

Perhaps try adding the below prior to End With

Please Login or Register  to view this content.

[PRodgers]

Perhaps try adding the below prior to End With

Please Login or Register  to view this content.

Thanks donkeyote