Defining a Named Range using Offset

Hi,

Does anyone know how I can define a named range using Offset in Vba?
I recorded the following macro to get an idea of what I needed but I'm unsure how to adapt it for Offset

Sub Macro8() 
'
' Macro8 Macro
' Macro recorded 08/10/2012 by Baz
'

'
    Range("C423:C427").Select
    ActiveWorkbook.Names.Add Name:="Test", RefersToR1C1:= _
        "='Sheet1'!R423C3:R427C3"
End Sub

I tried a few things but have been unable to get any variation to work. I need it to give a selected range a name and the name needs to be the value of a textbox on a userform.

For example

Range(rCl.Offset(1, 0), rCl.Offset(2, 0)).Select
        Selection.ActiveWorkbook.Names.Add Name:= Me.txtRange.Value

Thanks in advance