Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Application.WorksheetFunction.Match problem Carl Brehm Excel Worksheet Functions 1 January 9th 05 03:08 PM
Problem using "Find" WorksheetFunction in Excel VBA wadeni Excel Programming 1 August 12th 04 02:49 PM
WorkSheetFunction.CountIf & WorkSheetFunction.SumIf with 2 conditions? Etien[_2_] Excel Programming 3 January 13th 04 05:07 PM
WorksheetFunction Mike Fogleman Excel Programming 2 January 2nd 04 12:17 AM
worksheetfunction devnext Excel Programming 1 October 29th 03 01:48 PM


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

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright ©2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"