HonedLogic.com

Excel Articles

Copy & Pasting Formatting

Copying the formatting of one group of cells to another is something that can be achieved using Excel’s copy and paste options, but there is a simpler way. On the home ribbon there is an icon for the Format Painter, which has two modes of operation. If this is news to you then check out this:
Format Painter

How to Reduce the Size of a Workbook.

Workbooks, especially those stored on a network, have a habit of unexpectedly bloating in size. Rather than copy and paste your data into a new workbook you can fix the problem with the help of this guide:
How to Fix Bloated Workbooks

VBA: Speed up Macros

Improving the execution speed of your Excel VBA (macros) is really simple when you know how.
How To Speed Up Excel VBA Macros

VBA: Recursively List Files in Folders and Sub-Folders

There are times when you need to list all of the files in a folder and its sub-folders. The Excel VBA dir() function does not support this on its own, so a little bit of recursive programming is required.
Recursive Dir() in Excel VBA

VBA: How to Send Emails

Harness the power of Excel VBA (macros) to send customised emails by reading this article:
Excel VBA Emails!

VBA: How to Create Custom Toolbars

Rather than add lots of command buttons to a spreadsheet, it looks more professional to create a custom toolbar to the Add-Ins menu. Read this article for a quick guide.
Excel VBA Add-Ins Menu

VBA: How to Convert Column Numbers to Letters

Most Excel VBA macros need to reference ranges of cells but sometimes you need to convert a column number to a letter or vice versa, and it is not obvious how to do so. If you find yourself in this situation then check out this article:
Excel VBA Column Letters & Numbers

VBA: Graphics Demo

Although Excel was not designed with a programmatically accessible bitmap, one can be created by shrinking the cells so that they can be treated as pixels. Here’s a little demo to show what can be achieved.
Excel VBA Graphics Demo