View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] hermac@pandora.be is offline
external usenet poster
 
Posts: 18
Default FIND method doesn't work in UDF. What's wrong with this code?

Hallo Bernd,
Thanks for your help.
But how can I debug a code with only one line ?
And by the way, what do you mean by
"Use non-volatile
INDEX(P11:IV65536,1+w,1+y):IND*EX(P11:IV65536,w+y, x+z)
instead of volatile OFFSET(P11,w,x,y,z). "

Kind Regards,
Herman