How to keep formulas in excel intact while writing into excel

[Athawale_Rushikesh]

Hi All,

I want to keep excel formulas intact even while writing the excel range.

I have an excel file where few cell contains formula, hence when bot write the range, it gets over written with empty cells and formulas will not be there to calculate.

Seeking suggestions/ help to work the above scenario.

Thanks
Rushi

[Anil_G (Anil Gorthi)]

Hi @Athawale_Rushikesh

If you are writing data then try using write cell instead in the columns where you know there would be formula… other columns you can write directly.

Again mind the format that your formula meeds and use text() or something to convert your values using write cell

Cheers

[Athawale_Rushikesh]

Got the solution,

Just use write cell, feed cell range - starting cell till the last non blank row cell. Pass formulae.

It will update the cell formulae to entire range provided.

Find reference below

Regards,
Rushi