Need help with cells.find and do if looping

I have been trying to adapt the following code

Sub Test()
Dim C As Range
With Range("C2:C15")

Set C = Cells.Find("#N/A")
If Not C Is Nothing Then
        firstAddress = C.Address
        Do
        LR = Sheet2.Cells(Rows.Count, "A").End(xlUp).Row
        Union(Cells(C.Row, 1), Cells(C.Row, 2), Cells(C.Row, 3), Cells(C.Row, 4)).Copy Sheet2.Cells(LR + 1, "A")
        Set C = Cells.FindNext(C)
        Loop While Not C Is Nothing And C.Address <> firstAddress
End If
End With
End Sub

What I need it to do is look only in column C for cells that are not = to "#N/A"
currently it finds N/A's in Multiple columns and returns an entry for each.

I realize the union code is not required for this example but it will be for other iterations of the macro