Evaluate or WorksheetFunction Problem
 

Hello:

I have the following SUMPRODUCT formula in a worksheet cell:

=SUMPRODUCT((MYSHEET!$P$12:$P$999="RR")*(MYSHEET!$ V$12:$V$999<"OPEN")*(MYSHEET!$AL$12:$AL$999))

I am trying to recreate this formula in VBA using the Evaluate or
WorksheetFunction feature, but am running into problems. How can I
recreate this formula in VBA.

"Pigs can't be humans, but humans can be Pigs!"

Eating at the trough of life.

Oink!

SowBelly

Evaluate or WorksheetFunction Problem
 

Using Excel 2002,

Evaluate("SUMPRODUCT((MYSHEET!$P$12:$P$999=""RR"") *(MYSHEET!$V$12:$V$999<""OPEN"")*(MYSHEET!$AL$12: $AL$999))")

works for me. Maybe you weren't using the double double-quotes ("") to
indicate the " character within the string.

"SowBelly" wrote:

Hello:

I have the following SUMPRODUCT formula in a worksheet cell:

=SUMPRODUCT((MYSHEET!$P$12:$P$999="RR")*(MYSHEET!$ V$12:$V$999<"OPEN")*(MYSHEET!$AL$12:$AL$999))

I am trying to recreate this formula in VBA using the Evaluate or
WorksheetFunction feature, but am running into problems. How can I
recreate this formula in VBA.

"Pigs can't be humans, but humans can be Pigs!"

Eating at the trough of life.

Oink!

SowBelly

Evaluate or WorksheetFunction Problem
 

Ryan:

Looks like this was the problem.

Oink!

SowBelly

On Thu, 26 Aug 2004 22:39:04 -0700, Ryan Poth
wrote:

Using Excel 2002,

Evaluate("SUMPRODUCT((MYSHEET!$P$12:$P$999=""RR"" )*(MYSHEET!$V$12:$V$999<""OPEN"")*(MYSHEET!$AL$12 :$AL$999))")

works for me. Maybe you weren't using the double double-quotes ("") to
indicate the " character within the string.

"SowBelly" wrote:

Hello:

I have the following SUMPRODUCT formula in a worksheet cell:

=SUMPRODUCT((MYSHEET!$P$12:$P$999="RR")*(MYSHEET!$ V$12:$V$999<"OPEN")*(MYSHEET!$AL$12:$AL$999))

I am trying to recreate this formula in VBA using the Evaluate or
WorksheetFunction feature, but am running into problems. How can I
recreate this formula in VBA.

"Pigs can't be humans, but humans can be Pigs!"

Eating at the trough of life.

Oink!

SowBelly