Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.programming




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




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 doublequotes ("") 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




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 doublequotes ("") 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 
Display Modes  


Similar Threads  
Thread  Forum  
Application.WorksheetFunction.Match problem  Excel Worksheet Functions  
Problem using "Find" WorksheetFunction in Excel VBA  Excel Programming  
WorkSheetFunction.CountIf & WorkSheetFunction.SumIf with 2 conditions?  Excel Programming  
WorksheetFunction  Excel Programming  
worksheetfunction  Excel Programming 