Copypaste range not filling

I update formula and try to fill entire range via formula till the end… it does not support me as BOT completed without any error.

FLM.xaml (7.0 KB) Test.xlsx (11.6 KB)

Hy,

You could paste the formula in just one cell and then use an activity from this custom package:

image

Auto Fill

image

Regards

excel extension scope does not support on excel scope, pls look;

This custom package have a diferent scope from the default one, it will work :slight_smile:

where we need to place in my file for extension scope

Hy,

I reviewd your workflow, I would suggest you use the “LookUpDataTable” Activity instead of VLookUp.

Please take a look at my workflow.

VLookUpDemo.zip (27.2 KB)

Its work perfect, thanks

1 Like

Glad I could help :slight_smile:

Instaead of trying to emulate what we would do as it we were doing it in Excel, we must try to learn the UiPath way of doing things.

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