Just some more thoughts. Pressing the F9 buton and getting the correct
results means that the calculations didn't complete, not that the
formula is wrong which is what you are saying. so you have to start
thinking why the formula didn't complete. The obvious answers is there
some error or the dependencies chain of events is being broken.


Lets see if there are errors. A common problem when soembody goes from
one version of excel to another on the same PC or even differnt PC is
the break option is different. Try changing the following VBA menu


Tools - Options - General - Error Trapping.


Set the error trapping to "Break on all Errors". Maybe this will give
some clues. I can't tell if your formula is giving valid rows and
column locations. Maybe you are getting an error becuse your row/column
is less than 1, or you column reference is greater than 256.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=180681

Microsoft Office Help