Problems introducing a formula using VBA
Hello!
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:
{=SUM(IF(Hoja1!A2:A529="A";IF(ISNUMBER(Hoja1!B2:B5 29);IF(Hoja1!B2:B529>=5;1;0))))/COUNTIF(Hoja1!A2:A529;"A")}
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.
MARIONA
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.
|