How can I modify Wallenbachs UDF to show the "Worksheet
Name" of the referenced worksheet and or the fullpath?

Function SHEETOFFSETNAME(offset, Ref)
' Returns cell contents at Ref, in sheet offset
Application.Volatile
With Application.Caller.Parent
SHEETOFFSETNAME = .Parent.Sheets(.Index +
offset).Range(Ref.Address).Value
End With
End Function

Thanks....
..