topic RE: How to Apply formula to entire cell using Blueprism in Digital Exchange

How to Apply formula to entire cell using Blueprism

kirtish_trivedi — Thu, 17 Sep 2020 04:39:00 GMT

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
------------------------------

RE: How to Apply formula to entire cell using Blueprism

shashank.kumar280 — Thu, 17 Sep 2020 05:12:00 GMT

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
------------------------------

RE: How to Apply formula to entire cell using Blueprism

NupurSood — Thu, 17 Sep 2020 06:19:00 GMT

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
------------------------------

RE: How to Apply formula to entire cell using Blueprism

amaterano — Mon, 01 Aug 2022 10:20:00 GMT

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
------------------------------