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


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

Hi @nsharma

Can you attach a workflow?


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

1 Like

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