macro to unmerge cells

[paul_20k]

Hi Everyone

I am trying to unmerge cells in a single excel sheet, can anyone please help me as how to do it? I am new to macro and stuff...

Thanks

[tony h]

If you want to unmerge all cells on a worksheet. Select the sheet press <control>A then using the menus format...cells...Alignment and click on Merge Cells until the box is clear (unticked).

If you want to know how to code this use tools..record macro. Look in help for instructions on using record macro.

If you need more help let us know.

Hope this helps

[paul_20k]

Thanks for your reply Ton..I will keep you updated if I will have any other problem.