Problems introducing a formula using VBA
I'm trying to automatize with a macro in VBA how to do a chart. I have already done it manually (introducing the formulas by Excel) but now I can't do that using de Property Formula or FormulaArray.
I read in the Excel Help than there were array formulas which allows you to count values that comply with two conditions by pressing CTRL+Shift+enter altogether.
Look the original formula is:
and I put ranges variables instead of the direct references to cells.
Another thing is that I don't know how to add in the content of a string the quotes.
Thank you in advance.
PS. I bought the Excel 2002 VBA Programmer's Reference and I've found it very useful, but I haven't been capable to found enough help to the problem I mention above.