Thread: .Precedents don't work in UDF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andruha Andruha is offline
external usenet poster
  
Posts: 1
Default .Precedents don't work in UDF

I need to use the precedents of the cell that is the argument of
user-defined function as well as the cell itself. But if I write
Function MyFormula (MyCell as Range)
MyCell.Precedents don't work in this function. What can be done wit
it

--
Andruh
-----------------------------------------------------------------------
Andruha's Profile: http://www.excelforum.com/member.php...fo&userid=3595
View this thread: http://www.excelforum.com/showthread.php?threadid=55745

Reply With QuoteReply With Quote