View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach Otto Moehrbach is offline
external usenet poster
 
Posts: 1,090
Default 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?