Remember Me?

#1
Posted to microsoft.public.excel.programming
 external usenet poster Posts: 13
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
#2
Posted to microsoft.public.excel.programming
 external usenet poster Posts: 10
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

#3
Posted to microsoft.public.excel.programming
 external usenet poster Posts: 13
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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Carl Brehm Excel Worksheet Functions 1 January 9th 05 03:08 PM wadeni Excel Programming 1 August 12th 04 02:49 PM Etien[_2_] Excel Programming 3 January 13th 04 05:07 PM Mike Fogleman Excel Programming 2 January 2nd 04 12:17 AM devnext Excel Programming 1 October 29th 03 01:48 PM

All times are GMT +1. The time now is 06:21 AM.