Saturday, 21 November 2009

Excel Macros in Excel 2007: Selection.Unmerge

Excel 2007 help menu system is a gimmick. In fact, the whole of Excel 2007 is a graphical gimmick. Previous versions were imperfect yet better-designed. But here our priority is to discuss macro action in Excel. Wherefore art thou macros? Click on: View->Macros->Record Macro. Once recorded, you can do View->Macros->View Macros.

One useful and simple macro is Selection.Unmerge. Reason for this is when you need to highlight columns and can't do so - primarily because of MERGED CELLS. Probably those cells got merged as a result of cut-and-paste operation gone wrong.

No comments: