VBA Code of an Array Formula

**ROLLET** · 12-10-2007, 04:26 AM

={SUM(Quantity*Price)} this formula can be done thru CTRL + SHFT+ ENTER
However, how should we code it using VBA Code? Thanks!

**VBA Noob** · 12-10-2007, 04:29 AM

Maybe

Please Login or Register  to view this content.

VBA Noob

**ROLLET** · 12-10-2007, 09:50 PM

Converting Excel Array Formula to Excel VBA Coding
I have this formula with array after hitting CTRL+SHFT+ENTER

{=SUM(IF(BSmo!$F$7:$Q$7=BS!$A$5,IF(BSmo!$D$13:$D$101=BS!D13,BSmo!$F$13:$Q$101)))}

However when I tried converting to VBA Code it does not work..Could someone help me how do code this? And what is the coding for putting an array which in Excel we just hit CTRL+SHFT+ENTER

**mikerickson** · 12-10-2007, 10:08 PM

Welcome to the forum.

Do you want to use VB to put that formula in a cell?

Or do you want to write a VB routine that will return the same result as that formula?

**ROLLET** · 12-10-2007, 10:20 PM

I want to know both procedures..then eventually I will just use the easier procedure with the same result..Thanks!

**nattasiray** · 12-10-2007, 10:28 PM

Dear Rollet

Please Using Macro Recorder to Get the code

Tools --> Macro --> Recording Macro

Then Put the formula in cell

Tools --> Macro --> Stop Recording Macro

Press Alt+F8 Then click Edit button to see the code.

**mudraker** · 12-11-2007, 04:00 AM

Why was this done as a Poll question

What you have asked is not a poll

**VBA Noob** · 12-11-2007, 04:04 AM

mudraker,

I did tell Rollet before about this and he also posted a similar thread.

Rollet,

Please read the forum rules below again. If you continue to ignore them the posts may be deleted or you may be banned.

VBA Noob