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 02: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 04:07 PM
WorksheetFunction Mike Fogleman Excel Programming 2 January 1st 04 11:17 PM
worksheetfunction devnext Excel Programming 1 October 29th 03 12:48 PM


All times are GMT +1. The time now is 03:17 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"