Error in formula when concatenating results


Hi Lawrence,

I have to post a concatenated result of a Min and Max calculation in one cell as follows:

formula = “MIN(A1:A5) & “” | “” & MAX(A1:A5)”

Cells(“A2”).Formula = Formula

But I get an invalid formula error. I do not need to have it refreshed by using the Aspose Refresh funciton, but do need it when the user opens the spreadsheet with Excel.

Any ideas?


Please try this attached fix. And please chang your code to:

formula = "=MIN(A1:A5) & "" | "" & MAX(A1:A5)"


Works great!

Thanks Laurence