I have a function, I would like it to subtract dates from me and create a new column. However, it does not work, it shows me an error here
"Application - definied or object - definied error :
VBA Code:
.Value = Evaluate("if({1}," & .Offset(, -2).Address & "-" & .Offset(, -1).Address & ","""")")
VBA Code:
With wbMe.Sheets("Arkusz3").Range("G2", Range("A" & Rows.Count).End(xlUp).Offset(, 1))
.Value = Evaluate("if({1}," & .Offset(, -2).Address & "-" & .Offset(, -1).Address & ","""")")
End With