How do I select multiple ranges of cells in Excel VBA?

How do I select multiple ranges of cells in Excel VBA?

Select multiple ranges with VBA

1. Range(“A84:B”, “D84:E”, “H84:J” & LastRow). Select.
2. Range(“A84:B,D84:E,H84:J” & LastRow). Select.
3. Range(“A84:B & LastRow,D84:E & LastRow,H84:J & LastRow”). Select.

How do I select a range of data in a cell in Excel?

Select one or more cells Or use the keyboard to navigate to it and select it. To select a range, select a cell, then with the left mouse button pressed, drag over the other cells. Or use the Shift + arrow keys to select the range. To select non-adjacent cells and cell ranges, hold Ctrl and select the cells.

How do you reference multiple ranges in Excel?

When writing formulas we sometimes need to create references to multiple cells or ranges. One quick way to do this is by holding the Ctrl key and then selecting the cells or ranges. Excel will automatically add the commas between the range references in the formula.

How do I find the range in Excel VBA?

The Syntax of the VBA Range Property

1. Example #1–Select a Single Cell.
2. Example #2–Select an Entire Row.
3. Example #3–Select an Entire Column.
4. Example #4–Select Contiguous Cells.
5. Example #5–Select Non-contiguous Cells.
6. Example #6–Select a Range Intersection.
7. Example #7–Merge a Range of Cells.
8. Example #8–Clear Formatting of a Range.

How do you specify range of cells?

Press F5 or CTRL+G to launch the Go To dialog. In the Go to list, click the name of the cell or range that you want to select, or type the cell reference in the Reference box, then press OK. For example, in the Reference box, type B3 to select that cell, or type B1:B3 to select a range of cells.

How do you select a range of cells in Excel without dragging?

To select a range of cells without dragging the mouse:

1. Click in the cell which is to be one corner of the range of cells.
2. Move the mouse to the opposite corner of the range of cells.
3. Hold down the Shift key and click.