Priorsheet Function Problem
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
|