Hello

How can i print this formula in macro vba?

 =IF(B2<>0,ITEMS!F2,"")
i use this code but not working, getting object error

    Sheet6.Range("E2") = "=IF(B2<>0,ITEMS!F2,"")"
Thanks