Hi,

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!
Many thanks

The cell needs to be formatted as General instead of Text.


-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows run faster.
It is easy until you know how.

Thanks Brian. However, the cell was already in General format. I solved the issue by deleting the original sheet and inserting a new one. The problem hasn't recurred. It seems that the original user prevented calculation when they recorded the original macro, as all copies of that workbook had the same problem.

Regards,
Tim