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

David,

Are you passing a cell to each function? Is the function on a sheet that follows another sheet, and
is not the first sheet, or following a chart?

HTH,
Bernie
MS Excel MVP


"David" wrote in message
...
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

I found the problem...I'm an idiot. I made some changes to the master sheet
and that caused the errors. All I had to do was click on the cell to reset it
and it's all fine now. Thanks so much for the comeback!

"Bernie Deitrick" wrote:

David,

Are you passing a cell to each function? Is the function on a sheet that follows another sheet, and
is not the first sheet, or following a chart?

HTH,
Bernie
MS Excel MVP


"David" wrote in message
...
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