Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using code instead of worksheet functions
I find myself in the position of having to use code instead of functions.
My original function in E7 was as follows: =SUMPRODUCT((rng={"L","CL"})*(LEFT(rng2)="B")*(rng 3="")) I have put the following into the Worksheet Activate event of the new file but it doesn't appear to work: Range("E7").Value = Evaluate("SUMPRODUCT((rng={""L"",""CL""})*(LEFT(rn g2)=""B"")*(rng3=""""))") Thanks in advance. Gareth |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Excel to return Hiragana using code/char functions | Excel Discussion (Misc queries) | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
How do I use Excel Built-In Functions in Code? | Excel Worksheet Functions | |||
Where can I see VBA code for financial functions? | Excel Worksheet Functions | |||
Using Built in Functions in VBA Code | Excel Programming |