Priorsheet Function Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PriorSheet Function 1
Emailing Worksheet with VBA Code 6
Excel. VBA match doesnt work while WS does 0
Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
UDF x worksheet functions 3
Optional argument as Variant not acting like number 4
SumProduct 3d 9

Back
Top