You will have to use the PasteSpecial method to avoid changing your cell
format when copying data from other cells. i.e. Copy PasteSpecial
xlValues

"Khanjohn" wrote:

Once you have put in the borders etc you want is there a way to keep them
from changing if you copy text.formulas etc.. IR i use the med to large line
fo routside and it chages all the dime when I copy a smaller line in.

Any Ideas? or is this impossible to control?