Write Cell - Formula Not Calculating

excel
activities

#1

Hello All,

I am using Write Cell Activity to write a formula into excel cell, which it does successfully, but the actual value is not calculating. For example: The formula pastes as:

=VLOOKUP(R2,Validation!$A$1:$C$910,2,0)&H2&VLOOKUP(R2,Validation!$A$1:$C$910,3,0)

not giving me the value of “Successful” as it would have if I pasted the formula itself into the cell and pressed enter.

This may be a simple solution, but I’m not seeing it. Please help!

PS. I’ve tried using k[enter], no success.


#2

Hey @Geek

have you checked Some already exists posts on the forum?

Excel Formula in write Cell

Fastest way to write an excel formula into an entire column

Write Excel Formula for Row Count

And you are using Excel application scope or Write cell of workbook ?

Regards…!!
Aksh


#3

I’m using Write Cell of Workbook. But, switching to Excel Scope and then using Write Cell of Excel worked, Thanks!!