Solved: Selecting a Range of Rows

[Opv]

What is the proper syntax for selecting a multiple rows (both contiguous and non-contiguous) with Rows()?

[geekgirlau]

Do you actually want to select them, or just to perform some kind of action on them? Most of the time selecting anything in vba is not required.

[Opv]

Do you actually want to select them, or just to perform some kind of action on them? Most of the time selecting anything in vba is not required.

"Select" was the wrong word. I was just talking about how to reference rows using Rows() to define the range on which I want to perform an action. For example, rows 5-50 as opposed to rows 5,15,25,50, etc.

Also, when I type in "Rows(" in the code editor, the system displays "rowindex, columnindex" so I get confused whether I can enter column information or whether Rows is just limited to row numbers.

[geekgirlau]

Depends on what you want to do, but you can use something like:


Dim rng As Range

Set rng = Range(shData.Rows(1), shData.Rows(50))

rng.Interior.ColorIndex = 4



or


Dim i As Long

For i = 1 To 50
shData.Rows(i).Calculate
Next i

[YasserKhalil]

What is the proper syntax for selecting a multiple rows (both contiguous and non-contiguous) with Rows()?

Rows("1:50")

Range("5:5,15:15,50:50")

[Opv]

Rows("1:50")
Range("5:5,15:15,50:50")

Thanks, but the second example (using Range) is resulting in an error "wrong number of arguments."

[YasserKhalil]

Dim rng As Range
Set rng = Range("5:5,15:15,50:50")
rng.Interior.ColorIndex = 4

[Opv]

Dim rng As Range
Set rng = Range("5:5,15:15,50:50")
rng.Interior.ColorIndex = 4


Now that worked. When I just tried:


Range("5:5",15:15,50:50").select


I got an error. Oh well, thanks.

Opv

[mdmackillop]

When I just tried:


Range("5:5",15:15,50:50").select


I got an error.
That's because of the extra "

[Opv]

That's because of the extra "

Thanks.