I have the following line of code that should place a formula in a cell. ThisWorkbook.Worksheets("Log").Range("AA1").Formula = "=IFERROR(UNIQUE(FILTER(Log!$E$2:$E$100, Log!$E$2:$E$100<>" & Chr(34) & Chr(34) & ")), " & Chr(34) & Chr(34) & ")"
The desired formula result should be...