VBA advanced Function not executed when inserted by Macro

[Barbatian]

Dear All,

I couldn't find related topic but probably I didn't search right words.
Nevertheless I need to ask for help.

I have an "advanced" / "non-standard" function, which is called "abc" and workes as follows:
=abc("Name","Value","Number of Periods","Period Type")
What it does, it returns Values assigned to specific Name for specific period/periods in the past.
If I type:
=abc("Apple","Last Price","3","day") in cell "A1" it will return Last Prices of Apple from past 3 days:
A1 = 18.02.2018 B1 = 100 (fake price)
A2 = 17.02.2018 B2 = 101 (fake price)
A3 = 16.02.2018 B3 = 102 (fake price)

a function itself will be only in cell A1.
What it does, it connects to "data base" on server and collects data based on arguments given in "formula"/"function" and returns.

Now the problem is when I have a Macro, which inserts "abc" function, the function is not executed until I pause/stop/finish the Macro.
How Can I enable executing the "abc" function before going to next line of code in a separate Macro?

I would be very glad if you could help me

Best Regards,
Barb

 

[mikerickson]

Have you tried inserting the vba command Calculate immediately after putting the function in the cells?

 

[jproffer]

Deleted. Same answer as already given.

 

[Barbatian]

Hello,

Thank you for the answer however Application.calculate did not have any effect .

Regards,