MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Simulate Control Shift Enter in VBA

Posted by George on September 05, 2001 12:19 PM

Hi, can anyone tell me if its possible to enter an aray formula in VB ? meaning how to simulate the user pressing Control + Shift + Enter ?


Posted by Barrie Davidson on September 05, 2001 12:30 PM

George, try something like this.

Range("E1:E3").FormulaArray = "=Sum(R1C1:R3C3)"

Note that you must R1C1 reference style in your VBA code.

Hope this helps you out.


Posted by Peter on September 05, 2001 2:43 PM

Just use the macro recorder to find out the code.