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?
Any ideas how to force Excel to calculate properly?