I have a program where I use the AsFormula function.
This works fine with short formulas and when they references the same sheet.
I have som formulas like this:
(VLookup(D3;Sum!A28:G33;2)*E3)+(VLookup(D3;Sum!A28:G33;3)*F3);
When I compile and run the program, all works fine, but when I execute the function for creating the Excelfile, the resulting formula in the excel file looks like this:
=((VLOOKUP(D3;Sum!A28:G33;2;Sum!A28:G33;3)*F3))
I saw an earlier post about a simulur error that occured when referencing another sheet, in the reply it was said that this was fixed in a later release.
I have updated to the latest release bit I still get this error.
Olle.