Hi.. yeap .. sorry.. that line of code would normally be used like:


With Sheets("SheetID")
ActiveWorkbook.Names.Add Name:="GuestIP", RefersToR1C1:= _
            .Range("GuestIP").Offset(1, 0)

End With