merge and center cells using macro

I have this code:

Please Login or Register  to view this content.

I need to modify the code so the macro will also " merge and center" the cell with text and the next cell from row 3.
Please open the attached file.

Originally Posted by royUK

The best way to get code like this is to use the macro recorder, then edit the generated code. See

http://www.excel-it.com/record_macro.htm

I wouldn't actually recommened merging cells though

I already tried with macro recorder but I had no good result.

Originally Posted by royUK

What result did you get?

Do you actually mean to merge the cells, or center across selection?

This was my result but I wasn't able to adapt it to my code.

Please Login or Register  to view this content.

I need to merge the cells, two by two ...

I tried somethig like this without result:

Please Login or Register  to view this content.

I don't know if I was very clear ... please tell me and I will try to be more explicit