assistance in sub filter unique vba getting compile error invalid use of property

Hi All

The first code work wells but in trying to adapt to worksheet function

compile error invalid use property in red

I have a tab named workings and summary report.

In applying first code , works well but trying using worksheet function gets compile error invalid use property in red as per second code

Can anyone assist what is going wrong in second code in red

Please Login or Register  to view this content.

second code

Please Login or Register  to view this content.

Thank you