Tag Archives: Download

No Thumbnail

Excel VBA Chr() Function

In this article I will explain about the Chr() function. The Chr() function is a very useful function when working with strings and Excel columns. Generally speaking, numbers and characters are mapped. Meaning that each character is mapped to a number and vice versa. For

No Thumbnail

Excel VBA, Underline Font Style

This article explains the different types of underlines possible to apply to cells and ranges. It also provides the associated VBA code for adding the underline. For examples using these codes please see: Excel VBA Set Underline (Sample Code + Download) Excel VBA Get Underline

No Thumbnail

Excel VBA, Font Size

In this article I will explain how you can change the size of the font for a cell or range in Excel using VBA. I’ve also provided an example on how you can retrieve the size of the font used in a cell or range.

No Thumbnail

Excel VBA Print_UniqueTo_Column(), Sample Code + Download

In this article I will explain the function Print_UniqueTo_Column(). Print_UniqueTo_Column() is a function I’ve written in VBA for Excel. You can download the code and file related to this article here. Jump To: Input Parameters Example As Input it receives the location of a column of data and

No Thumbnail

Excel Pivot Tables (Example + Download)

In this article I will explain the PivotTable feature of excel along with 2 examples. You can download the file related to this article here. Jump To: What is a PivotTable and What is it Used for? Step 1: Creating an Empty PivotTable Step 2: