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?

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?

you can copy, paste special & choose just values, or just
formulas.....
then the cell formatting won't change.
hth
susan

On Apr 23, 6:16 am, 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?

thanks will try that.

"Susan" wrote:

you can copy, paste special & choose just values, or just
formulas.....
then the cell formatting won't change.
hth
susan

On Apr 23, 6:16 am, 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?