Thread: UDF not returning proper value - circular reference/multi workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.setup
 
Posts: n/a
Default UDF not returning proper value - circular reference/multi workbook
hi,

did you ever use Application.Volatile method in your UDF?
Volatile forces UDF run when a worksheet is recalculated.

for more information , goto
http://exceltips.vitalnews.com/Pages...alculated.html

Best regards,

sjoo

Reply With QuoteReply With Quote