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
In this article I’ve provided a sample code that will set the alignment properties of the cells in the first row using VBA. The user selects different alignment properties using the drop down lists provided. The program then updates the alignment properties of the cells in row
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
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.
In this article I will provide an example on how you could split a string based on a delimiter character using excel formulas and functions. You can download the workbook for this article here. Jump To: Function Used in this Example Summary Implementation Step 1, Indice Column
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
Adding (Concatenating) text in cells can be done using the “&” symbol. In the example below cell D2 adds (concatenates) the strings in cells A2, B2 and C2: Result: By modifying the values in the cells A2, B2 or C2 the value in D2 is automatically updated:
In this article I will explain the functions MID(), LEFT(), RIGHT(). The main purpose of these functions is to return a certain number of characters (substring) from a text. You can download the workbook related to this article here. Jump To: Syntax LEFT RIGHT MID
The following code is a function I’ve written which creates drop down lists. The drop down lists are created using data validation. It is assumed that there is a column with the drop down list values on one of the sheets. Another feature of this
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: