I know this is a ridiculously simple question but I cannot find th
solution anywhere on the net or in the help files. I have data in
cell that has a border around it and I want to be able to copy the dat
without the border to a cell on another sheet.

This code copies the border and the data:

Worksheets("Sheet1").Range("B4").Copy _
Destination:=Worksheets("Sheet2").Range("E5")

TIA
Ke

--
Message posted from http://www.ExcelForum.com