Hello,

I'm trying to put one big formula (one formula which contains others) in one cell using VBA but it does not seem to work.
It works when I put just one simple formula such as (that's just an exemple):
Range("O2").Formula = "=MAX(A1:A20)"
This works fine.
But now let's say I have 2 formulas:
Range("O2").formula = "=MAX(A1:A20)&" "&MIN(A1:A20)"
This does not work!
Althought if you use =MAX(A1:A20)&" "&MIN(A1:A20) in a regular EXCEL cell it works just fine.
It seems that VBA does not recognize the multiple forumlas that I'm aksing him to put in the cell.
However, it works just fine in Excel!
Does someone know how to go around this problem please?

Thank you!

P.S.: The actual formula i'm trying to use is much more complex. I'm just using MAX and MIN as an exemple to illustrate my problem.