| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel function problems
I have a UDF that I created to calculate golf handicaps. The problem is when ever I close the spread sheet and reopend it all the cells that contain the function have #VALUE! in the cell, I have to double click on the cell to get it to calculate. This happens all the time. I had the formula in a macro and it did the same thing. It used to take in 2 parms, but I've removed them and it still does the same thing. How can I get this to work. I've since put it into a Excel addin and have added it to my spreadsheets, but it still doesn't help. some times when I step through the function it seams like it loops around a few times but then does end? could this be becasue I have this funciton in several cells on each sheet? If I break at the end of the function, when it stops and I hit F8, it goes back to the beginning? The results are correct, but I'm not sure why it loops through, and why I have to recalculate every time I reopend the spreadsheet? Thanks, for any help -- mustanggt89 ------------------------------------------------------------------------ mustanggt89's Profile: http://www.excelforum.com/member.php...o&userid=23869 View this thread: http://www.excelforum.com/showthread...hreadid=375948 |
|
#2
|
|||
|
|||
|
Why not post the UDF's code?
"mustanggt89" wrote: I have a UDF that I created to calculate golf handicaps. The problem is when ever I close the spread sheet and reopend it all the cells that contain the function have #VALUE! in the cell, I have to double click on the cell to get it to calculate. This happens all the time. I had the formula in a macro and it did the same thing. It used to take in 2 parms, but I've removed them and it still does the same thing. How can I get this to work. I've since put it into a Excel addin and have added it to my spreadsheets, but it still doesn't help. some times when I step through the function it seams like it loops around a few times but then does end? could this be becasue I have this funciton in several cells on each sheet? If I break at the end of the function, when it stops and I hit F8, it goes back to the beginning? The results are correct, but I'm not sure why it loops through, and why I have to recalculate every time I reopend the spreadsheet? Thanks, for any help -- mustanggt89 ------------------------------------------------------------------------ mustanggt89's Profile: http://www.excelforum.com/member.php...o&userid=23869 View this thread: http://www.excelforum.com/showthread...hreadid=375948 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The description of the ATAN2 function in Microsoft Excel is not 1. | Excel Worksheet Functions | |||
| CHR() function not working in Excel 2003 | Excel Discussion (Misc queries) | |||
| Access Module coded converted to Excel Function | Excel Discussion (Misc queries) | |||
| Excel IF function for text | Excel Worksheet Functions | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Linear Mode
