recalculation not recalculating some cells containing user functio

V

velvetlady

I have the following situation:
1) workbook contains User Function macros in some cells.
2) #VALUE appears in some of the cells
3) if i select the cell and use "F2" to edit then the value is correctly
calculated
4) pressing "F9" will not cause the cells to recalculate nor will
5) running a macro containing the following
Application.CalculateFullRebuild
what must i do to force the cells to recalculate without having to
physically perform
#3 above on each cell.

thanks,
 
J

Jim Thomlinson

application.volatile

at the start of the UDF will make the function volatile and will cause it to
recalc with every calculation. The good new is it will racalc. The bad new is
that it will always recalc which has smoe overhead....
 
D

Dave Peterson

Make sure you pass all the ranges that your UDF uses to the function.

For more, er, better responses, you should post your code.
 

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

Top