Solved: Emulate Shift-Ctrl-Alt and F9 Keys..

[Wolfgang]

Good morning all (10:30 AM in Europe),

what is the VBA equivalent for said key-combination, please?!

Best,
Wolfgang

[HaHoBe]

Hi, Wolfgang,

have you tried:

Worksheets("Tabelle1").Range("E1:E3").FormulaArray = "=Sum(R1C1:R3C3)"
Application.Calculate
Ciao,
Holger

[Killian]

Hi Wolfgang,

the Calculate method (F9) can be also applied to a specified worksheet or range.ActiveSheet.Calculate

ActiveSheet.Range("A1:E10").Calculate

[Wolfgang]

Hi Holger and Killian...

I tried your suggestions and both worked just fine, thank you very much...

Have a nice weekend and best regards,

Wolfgang

PS: I will NEVER learn how to mark a post as "SOLVED"...