VBA Select command for Excel Elements

In Excel we deal with cells, rows, columns, worksheet, ranges, etc. Today, let us find how to identify these elements using vba.

range.pngcell

To use cells in vba we have to define as cell(1,1), which means the cell where the  first row and first column is intersected. The same we can define in vba in a different way as Range(“A1”), which is more simpler than cell, as there is no hardship in remembering column number, we can identify easily with alphabetical declaration of the column in excel.

To select A5, we can use:

Cells(5,1).select in which the starting 5 refers to the row and the latter refers to column.

or simpler way is:

Range(“A5”).select

VBA Beginners mostly use cells to identify the ranges. Better use Range command to refer the range element rather than defining cells. It will be easy to identify and remember as well.

Cells reference is used only when you want to select all the cells in a sheet.

Example: cells.select

or to clear all the contents of the sheet

Example: cells.clear

Range(“G5”).Select Selects Cell G5
Range(“D5, M10, Z16, ZZ202”).select Selects noncontiguos cells, A1, B2.
Range(“A1:E200”).select Selects ranges A1:E200
Range(“A1:B10,D6:Z20”).select Select noncontiguos ranges A1:B10 and D6:Z20
Range(“January”).select Select range named “January”
Range(“Order”,”Sales”,”Purchase”).select Selects named ranges Order, Sales, Purchase
Range(“Order”,”January”,”Sales”,”A6″).select Selects named ranges as well as cells A6

These are the different ways in VBA to select cells and ranges and named ranges.

For Sheets:

Sheets(“Order”).select

Sheets(“Purchase”).select

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s