Tag Archives: Cells

[Guide] How to Use Column Select in VBA

Selection of a Data Range in Excel In a Microsoft Excel document, serval operations like Delete, Edit, Type, and other formatting can also be done only if we select the range of cells on which we need to perform the change. There are several ways

Specialcells in VBA: 7 Critical Examples

What are Specialcells? Specialcells are a group of cells that belong to the same data type/format/color or have the same type of content like comments or blank. They are defined and used as a range object. This feature is useful when a change has to

How to Use and Print to the Console in VBA

Introduction While programming, it is always good to test parts of your code as you are writing it instead of writing the whole program, compiling it and running it — only to find out that it has a bug. In this article, you are going

No Thumbnail

Excel VBA, Horizontal Alignment

In this article I will explain the different horizontal alignment formattings applicable to cells and range. I have also provided the VBA code required to apply them. For examples using horizontal alignment in VBA code please see: Excel VBA, Set Horizontal Alignment, (Sample Code) Excel

No Thumbnail

VBA Excel, Alignment

The following article explains the different alignment formattingsĀ applicableĀ to cells and ranges and provides reference for more detailed explanation. When right click on a cell and select Format Cells … a dialog will open: The dialog has an alignment tab: The alignment tab displays all the