bab-concat.zip (8.5 KB)
We have a situation where we have a spreadsheet that has two worksheets. One of the worksheets has a formula like
=CONCATENATE("K{""One""", "{""two~~""")
If you run workbook.CalculateFormula() …... One of the worksheets has a formula...formula like =CONCATENATE("K{""one""", "{""two~~""") If you run workbook...