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
|