wrong data type?

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

VB Code:

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

Quote:

---

Originally Posted by Tobian

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

VB Code:

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

---

what is this along (sub)?
Application.Volatile

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

Quote:

---

Originally Posted by Tobian

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

---

No parameters?
Try

VB Code:

Call Application.Volatile

The bug is in the next row.

Application.Caller don't have any Offset methods

VB Code:

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