I coded a marco for Excel VBA. It enters a formula, which I have designed using the formula editor, into a cell of the excel spreadsheet. In oreder to achive this, I am using the following command:
Cells(1, 1).FormulaLocal = formula
It works just fine. However the data retrievel won't get updated until the macro has finished, which is beginning to become a major problem. Is there any way that a formula entered in a similar fashion gets updated? I looked into the API, but I am pretty lost there.
Thank you for any help.