Error in formula when concatenating results


#1

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?


#2

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

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


#3

Works great!



Thanks Laurence