Using "LocalFormula"

it isn't localformula, it is formulalocal

when you use formulalocal, the formula should be written as you would enter
it in a cell (including non-english works/names if that is how you work in
your spreadsheet).

--
Regards,
Tom Ogilvy

Markus Wilthaner wrote in message
m...
"Tom Ogilvy" wrote:
Either change the semi colons (;) to commas or use FormulaLocal rather
than
Formula (assuming your list separator is set to semicolon).

First, thanks for helping me out.
You were right, the semi colons are my list separator. Excel is smart
and replaces commas in the from-code-formulas with the semicolons.

I tried the same script on my Excel 2003 computer and it filled in the
formulas. However, all I get is an "Name" Error. When I edit the cell
(F2) and press enter without changing anything, it works! Odd....

Using "LocalFormula" causes my Excel 2003 to give me that 1004
Application error. :(

What I was trying to accomplish is to count the occurence of a giving
string in a number of cells, using SUMIF(<Range, <GivenString).

Thank you,


Markus