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:
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.
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 ?
I’m using Write Cell of Workbook. But, switching to Excel Scope and then using Write Cell of Excel worked, Thanks!!