PDA

View Full Version : Solved: Emulate Shift-Ctrl-Alt and F9 Keys..



Wolfgang
04-20-2006, 01:32 AM
Good morning all (10:30 AM in Europe),

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

Best,
Wolfgang

HaHoBe
04-20-2006, 02:03 AM
Hi, Wolfgang,

have you tried:

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

Killian
04-20-2006, 02:32 AM
Hi Wolfgang,

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

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

Wolfgang
04-21-2006, 12:46 AM
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"...