Does anyone know why following function gives me run-time error 424, object needed?
VB Code:
  1. Function LookOneBack() As Variant

  2.  
  3. Application.Volatile

  4. LookOneBack = Application.Caller.Offset(0, -1).Value

  5.  
  6. End Function