Is there a function to access Current Sheet minus one

[diverdarryl]

Is there a function to access the current sheet minus a set number of sheets such as the one I use in excel?

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

[erAck]

Calc knows relative sheet addressing i.e. without a preceding $, for example if you have sheets Sheet1, Sheet2 and Sheet3 and on Sheet2 enter the formula =Sheet1.A1 and copy&paste that formula to Sheet3 you get =Sheet2.A1

Not exactly the same, but…