Excel formula will not calculate

[mssbass]

It may be a bug in my workbook but using VBA, I'm placing my formula in A2 and bringing to the bottom. This works but formula is not calculating. My workbook is set to Auto-Calculate, I tried F9, I made sure my column is set to General. I've re-entered my formula in the cell and pressed enter but it is still not calculating. When I enter a simple formula in A2 as follows: = 1+2, it's calculating as 0.

Any ideas how to force Excel to calculate properly?

 

[Fluff]

Sounds like you might have a circular reference somewhere.

 

[mssbass]

Error Checking shows no circular reference. It's almost like I need some function to reset the entire sheet.

 

[mssbass]

I've created a new worksheet and the code works now - think it was a bug

 

[Fluff]

What happens if you use the evaluate formula button on the formulas tab, whilst A2 is selected?

 

[mssbass]

funny - it also evaluated 1+2 = 0 (CRAZY)

 

[Fluff]

Very odd.