Articles from May 2012



Find end of data ranges in Excel fast

This is a great tip and I’m often surprised at how many Excel users still don’t know this – here is how you can save lots of time when navigating around a dataset in an Excel workbook…     Navigation Problems There are plenty of occasions in Excel when you need to move around a [...]

Share

Protect Cells and Formulas in MS Excel 2010

There are times when protecting certain cells, formulas, or entire worksheets in Excel 2010 is a useful practice to adopt.  Read on to find out how to prevent your Excel 2010 worksheet from unplanned changes…     Protect Cells and Formulas in MS Excel 2010 When you protect a cell in MS Excel 2010 it [...]

Share

Open a Word document from Excel with VBA

If you need to use Excel VBA to open a Word document, or simply want to learn the concept, then read on to find out how, along with some useful tips on taking the script further…     There are many reasons why you might need to use VBA to open up a Word document [...]

Share

VBA Clear Entire Sheet in Excel

If you are looking for VBA to clear the entire sheet in Excel then look no more, read on to find out what VBA to use to clear the entire sheet and start with a blank canvas…     VBA Clear Entire Sheet With VBA it is possible to clear the entire sheet in Excel [...]

Share

Dynamic Named Ranges in Excel 2010

A named range is useful but a dynamic named range is the foundation of a fully automated Excel dashboard, learn how to make your ranges dynamic so updating Excel files becomes a thing of the past…     In a previous post we covered how to create named ranges in Excel 2010.  Now it’s time [...]

Share