View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Copy/PasteSpecial Not Pasting all Formatting

Maybe there are no borders in cell $K$13, but borders in neighbouring cells.

Regards,
Peter T

"Eric Weller" wrote in message
...
All,
I am moving the formatting (border, font, cell size, etc) from a cell on

one
sheet to a cell on another sheet by using copy and PasteSpecial. It works
fine except there are is a cell that does not get the borders copied. It
consistantly does not copy the borders from cell $K$13.
The code searches the worksheet looking for cells that contain the "<"
character. If it finds one, it copies the formatting to Sheet 1 to Sheet

2.
Here is the code I am using:

<snip