How to Apply formula to entire cell using Blueprism

[kirtish_trivedi]

Hi , I am trying to apply formula to entire cell in Excel from Blueprism.

I was able to paste the formula in one of the cell(M7) using Set Cell Value. Is there any option to fill the entire cell (M7:M[lastRow])?

------------------------------
Asia/Kolkata
------------------------------

[shashank.kumar280]

Hi,

You could also use the AutoFill action in the MS Excel VBO Extended to fill the formula up to the desired row.

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

[NupurSood]

Hello

You could use the action "Apply formula in Range" present in the "SPGMI - MS Excel Booster" vbo

------------------------------
Nupur Sood
Research Associate
S&P
Asia/Kolkata
------------------------------

[amaterano]

Hello 

This seems very simple, but today I forgot how to use this action:

In the "Cell Reference" parameter, place the range where the example formula will be: "Q2:Q10"
In the "Formula_for_top_cell" parameter, place the formula to be replicated, example: "=Month(A2)"

"Apply formula in Range" present in the "SPGMI - MS Excel Booster"



------------------------------
alirio materano
Consulting
SOAINT
Europe/London
------------------------------