Object does not support this property or method

Hi Guys,

I am getting this error "Object doesnot support this property or method"

What i'm tryin to do is, i have a data dump from SQl...
I want to compare some values from Sheet2 and then based on the result either look in some other cell in Sheet2 or return the value back to Sheet3.

The 0/1/1900 is the date that SQL is returning back to the excel file (that field in SQL is null)...

I want to run this code as a macro.. what am i doing wrong???

Sub Populate_Cells()

If Range("Sheet2!CW6") <> 0 / 1 / 1900 Then
Range(N6).Value = Range(Sheet2!CW6)
      ElseIf Range(Sheet2!CS6) <> 0 / 1 / 1900 Then
      Range(N6).Value = Range(Sheet2!CS6)
            ElseIf Range(Sheet2!AK6) <> 0 / 1 / 1900 Then
            Range(N6).Value = Range(Sheet2!AK6)
                ElseIf Range(Sheet2!AG6) <> 0 / 1 / 1900 Then
                Range(N6).Value = Range(Sheet2!AG6)
                Else
                Range(N6).Value = Range(Sheet2!AG6)
End If
End Sub