Excel 2007 : [SOLVED]Paste Value to next empty cell

[GaidenFocus]

Hey guys quick question, i have a macro that pastes cells to the next empty row on another worksheet

If Range("F8").Value <> "SD" Or "RD" Then
   last = Worksheets(Range("G8").Value).Cells.Find(What:="*", _
   After:=[A1], _
   Lookat:=xlPart, _
   LookIn:=xlFormulas, _
   SearchOrder:=xlByRows, _
   SearchDirection:=xlPrevious, _
   MatchCase:=False).Row
   sheets("SHIPREC").Range("D8:E8").Copy sheets(Range("G8").Value).Cells(last + 1, 1)
End If

how do i get it to paste the value only instead of the formulas? i tried paste special.