Excel 2007 : [Macro]Center

[andsoiwas]

Hello, I would like to request a macro code which horizontally centers the text in the cell and if it is already ready, it would return to to its default alignment..

Here is what I have recorded:

Please Login or Register  to view this content.

But this only centers.. and I want a code that is very much like the center tool in excel/word.
Thanks

[andsoiwas]

Ok found the solution:

Please Login or Register  to view this content.

reading the help of Vbasic helps