Using the code below, is there a way to paste special just the value,
and not the formatting.
I have the below taking data from Sheet (DATA) and pasting it in Sheet
(LOG). Right now it pastes the borders, value, and formatting.

Sub test()
With Worksheets("LOG")
Worksheets("DATA").Range("FULLNAME").Copy _
Destination:=.Cells(Rows.Count, 1).End(xlUp)(2)
Worksheets("DATA").Range("DEPT").Copy _
Destination:=.Cells(Rows.Count, 2).End(xlUp)(2)
End With
End Sub

Bull