Multiple rows select

[Philip00]

Hi All!

I would like to use multiple rows as range.

I have tried the following code with no luck_

Range("a1:aj1") & ("a3:aj3")

Can you help me with this issue?

Thank you so much in Advance,

Philip

 

[Joe4]

Try:

Range("A1:AJ1, A3:AJ3")

 

[Peter_SSs]

That would be as follows, but note that you rarely need to select anything to work with it in vba and selecting slows your code.

Range("a1:aj1,a3:aj3").Select

 

[Philip00]

Thanks Both of you!

Could you also help if i want to use "I" as variable

i have tried like this

Range("a1:aj1, A & i+1: AJ & i+1")

 

[Joe4]

Literal values go between double-quotes, variables do not.
So try:

Range("A1:AJ1, A" & i & ":AJ" & i)