Output Cell Value not Formula in VBA

[yoan6]

I have the code :

For Each cl1 In Table1
       
    cl1.FormulaArray = _
        "=MAX(IF(RC[-4]=(IF(VLOOKUP(RC[-1],Correspondance!R[" & i & "]C[-5]:R[" & j & "]C[-4],2,FALSE)=Log_WK!C[-3],Log_WK!C[-2],0)),Log_WK!C[-5],0))"
       
    If Not IsError(cl1) Then
        Result = cl1
    Else
        Result = ""
    End If
        
    Sheets("Date_Step").Cells(Date1_Row, Date1_Clm) = Result
    
    Date1_Row = Date1_Row + 1
    Step1_Row = Step1_Row + 1
    i = i - 1
    j = j - 1
       
Next cl1

As a result in my cell I have the formula not the value which must be like 01/10/2014 08:15:04

Could you tell me how I can get the value instead the formula?

Regards,

 

[Darren Bartrup]

Use Result = cl1.Value

 

[yoan6]

I already tried that but that doesn't work