Using Unique function in excel

[datauser]

Hi! I am attempting to use the unique function to copy a list of names two rows beneath my last used column in column B. This issue that I'm running into is that when the formula is placed in the appropriate cell, an @ symbol is placed in front of the unique. Any ideas on how to correct this.

Sub test()
Dim ws As Worksheet
Dim lastRow As Long

Set ws = ThisWorkbook.ActiveSheet

lastRow = ws.Cells(ws.Rows.Count, 2).End(xlUp).Row

ws.Cells(lastRow + 4, 2).Formula = "=UNIQUE(Query2!B:B)"

End Sub

Thanks!

 

[Fluff]

You need to use Formula2 rather than Formula

 

[ThatOneDude]

Try putting a 2 after Formula.

ws.Cells(lastRow + 4, 2).Formula2 = "=UNIQUE(Query2!B:B)"