Cell returns its own formula after a macro!
I've encountered a strange problem in a worksheet after I run a macro. After the macro is finished, the user wants to insert formulas in a particular column that concatenate "CS" with the contents of another cell i.e., ="CS"&BA1
However, the cell returns ="CS"&BA1
The problem is only in this particular worksheet whose output is heavily calculated by the macro. The workbook setting is "automatic calculation". In addition, the F9 key does not solve the problem, the formula just sits there! If I copy/paste the entire sheet to another new sheet, the formula calculates, but there is surely another solution to this.
Any suggestions are appreciated as this is driving me batty!