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
|