I have just run into something weird. I have two workbooks, using the same
PriorSheet Function, but one is giving me #VALUE! errors while the other is
working perfectly. Both sheets are password protected and use the
UserInterFace = True.
This is the function code I'm using:
Function PriorSheet(PriorCell As Variant) As Variant
Application.Volatile
PriorSheet = Application.Caller.Parent.Previous.Range(PriorCell .Address)
End Function

Can anyone help me figure out why the one is nothing working properly?

David