View Single Post
  #1 (permalink)  
Old July 31st, 2013, 10:37 AM
judy_bek judy_bek is offline
Registered User
 
Join Date: Jul 2013
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
Reply With Quote