I currently making a spreadsheet that consists of merge cells. Occasionally someone may need to de-merge the cells. I trying to make the sheet foolproof. Is it possible to have some code that when a cell is split it will automatically vertically align and set cell to shrink to fit. I have created a button to de-merge cells (just in case someone couldn't work out how). Could something be added to this to set the formatting of those cells? This could be applied workbook wide
Any help much appreciated.
Thanks
Bookmarks