by John MacDougall | Feb 22, 2017 | VBA
There may come a time when you need to know if a sheet in a workbook exists either during VBA code execution or as a result within the workbook. You may be creating and deleting sheets with your VBA code and will need to test if a sheet exists before it’s...
by John MacDougall | Feb 21, 2017 | Formulas
This post will explore how you can transform a table of values into a single column using the INDEX function. Get your copy of the example workbook with the above link. There are many ways you could transform a table into a single column but this post will explore the...
by John MacDougall | Feb 19, 2017 | Tutorials
Saving your workbook is important if you want to use or view the file again at a later time. It’s also a good idea to get into the habit of regularly saving your workbook while you’re working on it and not just at the end before you close the file. Saving...
by John MacDougall | Feb 12, 2017 | Tutorials
What Is The Status Bar? The Status Bar is the area at the very bottom in Excel where various information about the current mode or any special keys that are engaged can be seen. You can also select different worksheet views and zoom in and out on the worksheet...
by John MacDougall | Feb 11, 2017 | Tutorials
Cell A cell is the basic building block of a worksheet. Each worksheet contains a grid of cells in a 1,048,576 row by 16,384 column arrangement. Each cell can store data such as numbers or text or it can contain the results of a formula. Range A range is simply any...
