Tag Archives: Ranges

No Thumbnail

Excel VBA, Arrays and Ranges

When modifying worksheets and ranges,  one option would be to modify the worksheet directly using the commands I’v explained in the article Referencing Ranges In Excel Using VBA but that would be very inefficient. Every time you read or write something to an excel sheet, you will be consuming considerable

No Thumbnail

Sort A Range of Cells in Excel Using VBA

In this article I will explain how you can use VBA for excel to sort a range of cells. Example 1: Consider the range below. Assume we want to sort the range in ascending order based on column A: The following code will filter based

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

No Thumbnail

Referencing Ranges In Excel Using VBA

In this article I will explain how to work with the Range and Cell objects. While the terms range and cells may be used interchangeably, they are two different objects, and have different functions and properties. There are two main notations for referencing ranges: Range(“A1:B1”) notation Range( Cells(1,