Forcing a recalc to eliminate bad values

[db41987]

My current code:

Please Login or Register  to view this content.

Description:
One single workbook
10 sheets in the workbook, 3 of which are referenced in this macro

Bill = Bill of materials sheet...draws from several other sheets to calculate a COST value (H2) for a given model number
Models = Model numbers
Cost Pricer = Duplicate of Models except model numbers are replaced with costs (from Bill!H2)

When I calculate costs manually the values shown in H2 are correct everytime. If I run the macro and watch the values calculated it displays values that are erratic...sometimes higher, sometimes lower...than what the manual computation would provide.

My question is...

Is there a way to make Excel computate the first step, post an accurate value from H2, completely clear the memory, refresh the worksheet, computate the second step, post an accurate value from H2, completely clear the memory, refresh the worksheet, etc etc etc

Not sure if something like this would help?

Please Login or Register  to view this content.

I'm really stumped at why excel is returning bad values when I run the top macro above. The weird thing is that the values posted seem to change as I add more and more cells to the macro.