Hi Guys!

I´m making some automation with Excel. At the end, I´m making some formulas, something like this:

	nvorango = "I" + ALLTRIM(STR(lnFila))
	elrango = "I5:I" + ALLTRIM(STR(mifinal))
	WITH .RANGE(nvorango)
		.formula = "=SUBTOTALES(9," + elrango + ")"
	ENDWITH

This code returns something like this in the formula bar:

        =SUBTOTALES(9,I5:I3765)

It seems good but I get an #¿NAME? error on the cell. If I edit the cell WITHOUT any change, the result apears normal. It's the same thing with other kind of formulas.

Does anybody know how can I avoid this behavior? BTW, I´m using MS Excel 2003 (Spanish), but it's the same trouble in other versions.

Thanks in advance!