>Thanks for all that Della. Is there a way to change the Horizontal
>Text alignment aswell.

The Range object's HorizontalAlignment property does this. Set it to one of 8 constant values, such as xlHAlignCenter, which has the value of -4108.

VBA uses intrinsic constants--you see these when you use the Macro Recorder (which is a GREAT way to learn to automate Excel). VFP, however, does not have these values as a part of its language. To find these values, use an Object Browser. Excel's is available within Excel by Alt-F11, then F2 (just learn the keystrokes, it's faster! <g$gt). If you have VFP 7, use its own Object Browser. You can search for the constant name, and the value is shown in the bottom panel.

HTH,

- della