Disappearing grid lines
Thanks for the help but I think you misunderstood me. I want to copy only
the values, so I used the "xlPasteValues". This didn't copy the borders and
that's what I wanted. But now the grid lines around the destination cells
are gone. Not the borders but the normal sheet grid lines. Thanks again.
Otto
"Die_Another_Day" wrote in message
ups.com...
Because you told Excel not to. (xlPasteValues) use xlPasteAll to get
the borders.
Die_Another_Day
Otto Moehrbach wrote:
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?
|