Drag formulas in excel for a specific row using auto fill activity

[nsharma (neha sharma)]

Hi,

i have one excel files i need to drag formulas in it from range U to AH i used auto fill activity but i am getting this error:

i used source range as: “U”+LastRowIndex.ToString+" :" +“AH”+LastRowIndex.ToString
destination range as : “U”+totaldata.ToString+" :" +“AH”+totaldata.ToString

Please help

[PrankurJoshi]

Hi @nsharma

Can you attach a workflow?

Thanks,
Prankur

[nsharma (neha sharma)]

it worked now
i was not passing correct range.
changes it to this in destination.
“U”+LastRowIndex.ToString+" :" +“AH”+(LastRowIndex+1).ToString