Range definition using Cells

[wmbb]

How do I write the range ActiveSheet.Range(A5:B5,D5:AM5) using the cells notation ?
I want to define the range using row numbers and column numbers...

 

[Andrzejek]

From Referring to Excel Ranges
[tt]
ActiveSheet.Range(Cells(2, 2), Cells(5, 5)).Interior.Color = vbYellow
[/tt]
Makes Range B2-E5 yellow

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[SkipVought]

You might try,

With ActiveSheet
   Union(Range(.Cells(5, 1), .Cells(5, 2)), Range(.Cells(5, 4), .Cells(5, 39)))
End With

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[wmbb]

Thank you SkipVought,
You've pushed me in the right direction ;-)

 

[Andrzejek]

Did you solve your issue? If so, would you mind sharing it here for the benefit of others?

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[remeng]

If you want to make your life a little easier in determining the R1C1 value, you can switch the excel worksheets to R1C1 instead of Letter Row format.

Link