non absolute range valuse

[dinotom]

this line of code produce an absolute range address, how do you get it to do it in relative reference form?

ie it gives me $B$2:$B$79 when i want B2:B79

Range(Cells(2, rngTemp.Column), Cells(rngTemp.Offset(-1, 0).Row, rngTemp.Column)).Address

 

[dinotom]

i found the answer, you need to set the references to false ie
.Address(False,False)