I Want to apply =I2-E3+F3 in I3 cell of the excel then i want to auto fill range this formula to the remaing cells of the column

Please suggest a solution for this

1 Like

Hey @Gopikrishna_S

This can be performed using Datatable manipulation and updating back in excel.

Please share the sample excel, if you need a demo code.

Thanks
#nK

Hi @Gopikrishna_S,

You writecel activity -

image

Here instead of “A1” mention “I3”

then after this use AutofillRange activity -

image

Thanks

1 Like

Hi @Gopikrishna_S

You can try with invoke method (VB)

Regards
Gokul

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.