Garry W
Reputation: 311
How to select a column next to a named range?
The red range is called theRange. How do I select the yellow range using VBA code?
Upvotes: 0
Views: 133
Answers (1)
JNevill
Reputation: 50034
You can use the .Offset(<rows>, <columns>) method of the Range object to do this:
Range("theRange").Offset(,1).Select
Upvotes: 2
Related Questions
- Selecting cell by adjacent column name
- Selecting a Named Range Cell Location EXCEL VBA
- VBA Excel select a range of cells within a named range
- Select columns ranges in a VBA
- Selecting column range with specific header
- selecting a range within a range
- How do I select a range below a selected cell?
- Select column in a selected range VBA
- Selecting a whole column as a range rather than a named range
- VBA excel - using a variable to select a column range