Making a relative range in VBA

[aapjaap]

I wanted to make a relative range in VBA for excell.
Ho can i do this?

 

[Tom Ogilvy]

set rng = ActiveCell.Offset(5,4)