I have a problem when inserting a new column to my excel spreadsheet and thereafter writing a formula in the newly added column. The formula is inserted as text and not the value (as you see in the attached file). Furthermore, the formula will not change as if you drag the first cell manually in excel. The code worked when I did not insert a new column.
Do you have any good solutions to this problem?