View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don McC Don McC is offline
external usenet poster
 
Posts: 6
Default displaying intermediate results from a function procedure

Is there a way to write out to a worksheet intermediate (internal) variables
that are calculated in a function procedure. I have tried writing a sub
procedure that is called from the function procedure but that doesn't seem to
work. Makes the calling function not work and I get a #VALUE instead. In
that iteration, I was trying to print to the same worksheet that I am calling
the function procedure from,

Thanks