Need to specify a range using cells reference

[Bill_Biggs]

I need a line of code to specify a cell range where the cells constantly change values.

Psuedocode:

Range ((Cells(A,B)) : ((Cells (C,D)).Select

I can't seem to find the correct way of writing this. Any takers?

Thank you,

 

[VoG]

Like this

Range(Sheets("Sheet1").Cells(1, 2), Sheets("Sheet1").Cells(5, 4)).Select

You can omit the sheet qualifier if you are referring to the active sheet.

 

[Andrew Poulsom]

Example:

Sub Test()
    Const A = 1
    Const B = 2
    Const C = 10
    Const D = 4
    Range(Cells(A, B), Cells(C, D)).Select
End Sub

 

[Bill_Biggs]

That did it. Thank you.