Today when I was looking through the stackoverflow forum, I came up to this question: vba-clean-up-conditional-duplication-of-rows Though the question was actually VBA related I was able to find a solution that did not require any programming. Since the solution was challenging and interesting I thought
Various different patterns can be applied to cells in Excel. These patterns can be applied manually using the Format Cell dialog: This article will explain how you can apply different patterns to cells using VBA for Excel. Jump To: Basics Example 1, Set Pattern Example
The INDIRECT() function returns a reference specified by a text string. For example the formula below: =INDIRECT(“A1″) returns the value in cell “A1”. You can download the workbook related to this article here. Jump To: Syntax Example 1, Get Value From List, Based on Row Index Example
In this article I’ve provided an example on how you could use VBA to set underlines for cells and ranges. There are 4 different underline style the user can select from: Single Double Single Accounting Double Accounting For more information about the different underline types and their associate VBA code please
In this article I will explain how you can modify border thickness and style using VBA for Excel. For more information about creating borders please see Excel VBA, Create Border. In that article I’ve explained how you can create a border for the different sections of a
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 provide an example on how to set the vertical alignment of cells using VBA. The user selects the vertical alignment from a set of drop down lists. The selected vertical alignment will be applied to the cell below the drop down list. You can download the file and code related to this article here. Upon
The DATEVALUE() function receives as input a text string representing a date. The function returns as output the date value corresponding to the input date text string. Jump To: Syntax Basic Example Why? More Examples – Syntax: =DATEVALUE(Date_Text) Date_Text: A text string representing a date. – Basic Example:
This article provides a sample on using the color code in VBA for Excel. In this example the user inputs a color code in cell B1. The fill color in cell A1 is changed to the color defined by the color code in cell B1.
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.