Quote Originally Posted by BigBas View Post
Try this and report back.

Range("O2").Formula = "=MAX(A1:A20)&"" ""&MIN(A1:A20)"
Hello,

Thank you for your answer.
Great it works! but what did you do? Just add " and " ?

Now would you do the same if the actual formula is:

Range("O2").value= "=IF(LEN(D23)-LEN(SUBSTITUTE(D23,"[",""))>1,TRIM(MID(LEFT(D23,FIND("|",SUBSTITUTE(D23,"[","|",2))-1),FIND(">",D23)+1,255)),TRIM(MID(RIGHT(D23,FIND("|",SUBSTITUTE(D23,"<","|",1))+255),FIND(">",D23)+1,255)))"

Thanks again!

Edit: I used "," althought in my excel sheet I use ";" instead. I think in VBA "," should be used right?