http://snipplr.com/language/visual-basic/tags/ExcelMacro Recent snippets posted on Snipplr.com en-us Thu, 20 Jun 2013 19:09:45 GMT http://snipplr.com/view/36900/how-do-i-create-a-named-cell-in-microsoft-excel/ A named cell or range in Microsoft Excel enable users to quickly and easily remember a cell's reference name. For example, it's much easier to remember Total than it is to remember G23.

]]> Thu, 08 Jul 2010 08:52:19 GMT http://snipplr.com/view/36900/how-do-i-create-a-named-cell-in-microsoft-excel/ http://snipplr.com/view/28253/merge-cells-in-multiple-selected-areas-column-by-column/

]]> Fri, 12 Feb 2010 14:43:25 GMT http://snipplr.com/view/28253/merge-cells-in-multiple-selected-areas-column-by-column/ http://snipplr.com/view/28243/zoomout-excel-macro/ This macro sets the bottom boundary at 10%, which is the smallest you can go. Any smaller, and Excel would generate an error again.

]]> Fri, 12 Feb 2010 10:55:04 GMT http://snipplr.com/view/28243/zoomout-excel-macro/ http://snipplr.com/view/28242/zoomin-excel-macro/ Notice that the macro only allows you to zoom in up to 400%. This is because Excel allows you to only zoom that high, and any higher would generate an error. A slight variation on the same theme results in a macro I call MyZoomOut. It zooms out of (reduces) a worksheet by 10%:

]]> Fri, 12 Feb 2010 10:53:52 GMT http://snipplr.com/view/28242/zoomin-excel-macro/