I have made a macro which FILLS DOWN formulas into an MS EXCEL 2000
Spreadsheet. My macro calculates the formulas except some have "
#NAME? " as a value.


The crazy thing about this is that when I go into the status bar and
hit enter the formula is calculatedthe exact number comes up!!!! I've
heard about Microsoft issues, is this another example?


What should my calculation settings be?


I'm not sure if manual, automatic, iteration, or calculate before
save will help me out.


Please help. Thanks