Another way of writing a range in excel

[Chris6629]

'A range in Summary Tab
Sheets("Summary").Range("A3:A35") 'first way

'It can also be written in another way using Cells (x,y)
Sheets("Summary").Range(Cells(3,1),Cells(35,1)) 'another way

'Another range in Summary Tab
Sheets("Summary").Range("A3:A35,JA3:JA35")

'Question : How this range can be witten in the other way? Using Cells(x,y)?

Thanks you
Chris6629

 

[RoryA]

This is not correct:

Sheets("Summary").Range(Cells(3,1),Cells(35,1))

It should be:

Sheets("Summary").Range(Sheets("Summary").Cells(3,1),Sheets("Summary").Cells(35,1))

You can't directly convert your final example, you have to use Union:

Union(Sheets("Summary").Range(Sheets("Summary").Cells(3,1),Sheets("Summary").Cells(35,1)), Sheets("Summary").Range(Sheets("Summary").Cells(3,"JA"),Sheets("Summary").Cells(35,"JA")))

 

[Rick Rothstein]

You can't directly convert your final example, you have to use Union:

Union(Sheets("Summary").Range(Sheets("Summary").Cells(3,1),Sheets("Summary").Cells(35,1)), Sheets("Summary").Range(Sheets("Summary").Cells(3,"JA"),Sheets("Summary").Cells(35,"JA")))

This kind of matches what the OP was asking for (the Resize is "new") and seems to work as well...

Sheets("Summary").Range(Sheets("Summary").Cells(3,1).Resize(33).Address & "," & Sheets("Summary").Cells(35,10).Resize(33).Address)

 

[Chris6629]

Thank you very much