Solved, need to use formula2 = ?
++++++++++++++++++++++++++++++++++
Hi there,
I have this formula that works well
For some reason I need to add the formula with a VBA code which is
Sub Highest_Value()
With Sheets("Highest_trade")
.Range("B2").Formula = "=MAX(IF(Master!$K:$K=""EUR"",Master!$L:$L))"
End With
End Sub
But why vba the formula I get is as per below. Why an unneeded @ which gives a wrong result.
Why do I get that ?
Thanks
++++++++++++++++++++++++++++++++++
Hi there,
I have this formula that works well
For some reason I need to add the formula with a VBA code which is
Sub Highest_Value()
With Sheets("Highest_trade")
.Range("B2").Formula = "=MAX(IF(Master!$K:$K=""EUR"",Master!$L:$L))"
End With
End Sub
But why vba the formula I get is as per below. Why an unneeded @ which gives a wrong result.
Why do I get that ?
Thanks