Question

Set cell formula

  • 18 April 2022
  • 1 reply
  • 11 views

Hello!

 

I'm trying to add a formula in excel. This is the formula

=TRANSPOSE(Table1) which I enter in "set cell formula"

 

When I run the bot it adds this @ character to the formula in excel, and the formula doesn't work properly. 

Table 1 is defined in excel. 

 

=@TRANSPOSE(@Table1)

 

Thanks!


1 reply

Userlevel 4
Badge +8

Hello,

 

I request you to please create one variable and add this formula to that variable and use the same in the set cell formula command.

 

If you have any questions please let me know.

 

Thank you,

Prabhakar Jha

Reply