I am setting cell formula using excel advance package, but my cell formula has $ in it and its showing error in automation anywhere. How to set cell formula using $ in excel formulas?
I am setting cell formula using excel advance package, but my cell formula has $ in it and its showing error in automation anywhere. How to set cell formula using $ in excel formulas?
Userlevel 4
+7
Hi @sangam nath ,
Dollar signs are treated as variable initializations, so to use dollar signs, you have to escape it by adding another one i.e.
=$$A$$1+A2
Kind Regards,
Ashwin A.K
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.