How to Variable Reference Row Ranges?

[Guest]

I'm trying to use variables to reference row ranges but don't know the syntax
or correct command. Instead of using a command like:

Range("5:9")

I'm trying to reference a number of row groups i.e. 5:9, 10:14, 15:19 and
would like to be able to use a command like:

Range("var1,var2") but this doesn't seem to work.

Any ideas....

 

[JE McGimpsey]

One way:

one way:

Dim var1 As String
Dim var2 As String
var1 = "5:9"
var2 = "10:14"
Debug.Print Union(Range(var1), Range(var2)).Address

another:

Debug.Print Range(var1 & "," & var2).Address

 

[Gary Keramidas]

do you want to act on the entire row?

one way

Range(Rows(3), Rows(5)).Select

 

[Guest]

Use syntax like this:

Range("4:10,16:21,26:30").Select

Hope this helps,

Hutch

 

[Guest]

Tom...

Thx for your comment. Actually not trying to reference the rows at the same
time but conditional on other factors i.e.

If EventA then
Var1 = 10
var 2 = 14
else
Var 1 = 20
var 2 = 24
End if
Range("var1, var2")

Any thoughts?

 

[JE McGimpsey]

One way:

Range(var1 & ":" & var2)

Tom...

Thx for your comment. Actually not trying to reference the rows at the same
time but conditional on other factors i.e.

If EventA then
Var1 = 10
var 2 = 14
else
Var 1 = 20
var 2 = 24
End if
Range("var1, var2")

Any thoughts?