M
mustanggt89
I have a UDF that I created to calculate golf handicaps. The problem i
when ever I close the spread sheet and reopend it all the cells tha
contain the function have #VALUE! in the cell, I have to double clic
on the cell to get it to calculate. This happens all the time. I ha
the formula in a macro and it did the same thing. It used to take in
parms, but I've removed them and it still does the same thing. How ca
I get this to work. I've since put it into a Excel addin and have adde
it to my spreadsheets, but it still doesn't help. some times when I ste
through the function it seams like it loops around a few times but the
does end? could this be becasue I have this funciton in several cell
on each sheet? If I break at the end of the function, when it stops an
I hit F8, it goes back to the beginning? The results are correct, bu
I'm not sure why it loops through, and why I have to recalculate ever
time I reopend the spreadsheet? Thanks, for any hel
when ever I close the spread sheet and reopend it all the cells tha
contain the function have #VALUE! in the cell, I have to double clic
on the cell to get it to calculate. This happens all the time. I ha
the formula in a macro and it did the same thing. It used to take in
parms, but I've removed them and it still does the same thing. How ca
I get this to work. I've since put it into a Excel addin and have adde
it to my spreadsheets, but it still doesn't help. some times when I ste
through the function it seams like it loops around a few times but the
does end? could this be becasue I have this funciton in several cell
on each sheet? If I break at the end of the function, when it stops an
I hit F8, it goes back to the beginning? The results are correct, bu
I'm not sure why it loops through, and why I have to recalculate ever
time I reopend the spreadsheet? Thanks, for any hel