Don
I get the same thing you do with any of my files, old and new. The
problem is that the grid lines disappear on the OP's file. And not in all
cells. Just cells in a certain group of rows. He built his file on a MAC.
I know you feel the same as I do; frustrated.
I think I will try deleting all the rows in this group of rows. In
fact, I'll delete all the rows from the start of this group of rows down to
the bottom. Thanks for your time. Otto
"Don Guillett" wrote in message
...
d5 with borders
d6 standard grid lines stayed intact

Range("d6").Value = Range("d5").Value
just tested and it did NOT copy the borders or delete the normal grid
lines

--
Don Guillett
SalesAid Software

"Otto Moehrbach" wrote in message
...
Don
I tried a slight variation of what you said to match what I have. The
line of code is now:
Dest.Offset(cc).Value = j.Value
I changed the destination to a group of cells that I knew had grid lines.
Now those grid lines are gone as well. Any ideas? Thanks for your time.
Otto
"Don Guillett" wrote in message
...
try this instead of copy/paste
sheets("destinationsheet").range("d2:f3").value=
sheets("sourcesheet1").range("a1:c2").value=

note that the ranges need not be identical but they must be the same
size.

--
Don Guillett
SalesAid Software

"Otto Moehrbach" wrote in message
...
Excel XP, Win XP
I am copying a series of cells in a For loop and pasting them somewhere
else. The destination cells have the normal grid lines and no borders.
The source cells have borders around each cell. I am using the
following code:
j.Copy
Dest.Offset(cc).PasteSpecial xlPasteValues

After pasting, the destination cells have no grid lines. Why? And how
do I get the grid lines back? Thanks for your time. Otto
PS: I am helping an OP with this file that he built. He has a MAC and
I have a PC. Could this be a factor?