How to refresh a formula cell in Excel using Applescript
Greetings,
I am new to Applescript and I need help to refresh a cell in Excel.
Details :
In cell CF145, I have concatenate some data
In cell CG145, I have paste special value of CF145
The result of the paste special is the concatenate formula :
=(INDEX(D154:D253,MATCH(TRUE,INDEX(CC154:CC253>=0, 0),0))).
If I manually edit the cell CG145 and then hit the <Enter> key, the value of the formula is now correctly show in the cell.
My question is :how can I do this via Applescript?
Thanks in advance for helping.
Judy
|