'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
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