Select Range using Cells(r, c)?

[Desu Nota from Columbus]

How do you select a range of cells or individual cells using the Cells(r, c) notation?

1) Range("B2:E4").Select ---->

2) Range("A1, B2, C3, D4").Select ---->

 

[VoG]

Try like this

Cells(1,2).Select

Range(Cells(1,1),Cells(3,5)).Select

 

[Andrew Poulsom]

One way:

    Range(Cells(2, 2), Cells(4, 5)).Select
    Union(Cells(1, 1), Cells(2, 2), Cells(3, 3), Cells(4, 4)).Select

 

[Desu Nota from Columbus]

Thank you