Hi,

I need the vba code that will center align some text in a
text box for me - at the minute I have :

with oPPTShape
.TextFrame.HorizontalAlignment =xlHAlignCenter

And it doesn't work - any ideas please?

Many thanks
KDUT