hello! i have come accross a strange problem...it might just be me but here
it goes:
xl2007
i have a range (A1:L17) on sheet2 which i copy by macro to the bottom of
sheet1 every time i need to insert a new contract on sheet 1.
on sheet 2 i have conditional format formulas which apply to whole columns
e.g. B:B , E:K etc.
when this range is pasted on to sheet1 the cf interrupts for that range and
then continues below it.
the strangest thing is that if i apply a cf to the range on sheet2 then when
it is pasted on to sheet1 the cf does not interrupt.
obviously i don't want to have cf on sheet2 because then they create a new
rule on sheet1 every time the range is pasted.
Can anyone suggest a way to "trick" this occurence?
Thanks much