Automation

Switch Alerts off with Excel VBA

A common problem achieving full VBA and Macro automation with Excel is that the warning messages can halt your script in the middle of processing.  Learn how to stop that problem and achieve full Excel automation with VBA… The problem…
Read more

Named Ranges in Excel 2010

Learn how to create a descriptive name to refer to a range of cells on an Excel worksheet with this guide for Excel 2010 users… What is a Named Range? A Named Range is a text label that refers to…
Read more

How to use Hyperlinks in Excel 2010

Hyperlinks are a useful concept to understand in Excel, they are particularly helpful in large reporting suites or when creating winning Excel dashboards as they can be used as an effective navigational tool.  This guide will show you how to…
Read more