How To Select Range In Excel Vba

by

How to select range in Excel VBA

In Excel VBA, you can select a range of cells using the Range object. The Range object represents a cell or a range of cells in the worksheet. To select a range, you can use the following methods:

  1. Selecting a single cell: 
    Range("A1").Select
  2. Selecting a range of cells: 
    Range("A1:B5").Select
  3. Selecting a range using variables: 
    Dim rng As Range
Set rng = Range("A1:B5")
rng.Select

Here are a few examples to demonstrate the usage of range selection:

Example 1: Selecting a single cell

Range("A1").Select

Example 2: Selecting a range of cells

Range("A1:B5").Select

Example 3: Selecting a range using variables

Dim rng As Range
Set rng = Range("A1:B5")
rng.Select

Read more interesting post

Leave a comment