wrong data type?

[Tobian]

Does anyone know why following function gives me run-time error 424, object needed?

Function LookOneBack() As Variant
 
Application.Volatile
LookOneBack = Application.Caller.Offset(0, -1).Value
 
End Function

[oh1mie]

Does anyone know why understanding function gives me run-time error 424, object needed?

Function LookOneBack() As Variant
 
Application.Volatile
LookOneBack = Application.Caller.Offset(0, -1).Value
 
End Function

what is this along (sub)?
Application.Volatile

[Tobian]

I am working VB in Excel. It's a VBA function.

[oh1mie]

I am working VB in Excel. It's a VBA function.

No parameters?
Try

Call Application.Volatile

[Tobian]

The bug is in the next row.

[oh1mie]

Application.Caller don't have any Offset methods

Select Case TypeName(Application.Caller)
    Case "Range"
        v = Application.Caller.Address
    Case "String"
        v = Application.Caller
    Case "Error"
        v = "Error"
    Case Else
        v = "unknown"
End Select
MsgBox "caller = " & v