fear of a bug, hope for a workaround
 

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

fear of a bug, hope for a workaround
 

sorry typo,
correction:
.....on sheet1 i have conditional format formulas which apply to whole
columns..

"goodfish" wrote:

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

fear of a bug, hope for a workaround
 

IIRC, when you PASTE a range, you replace the formats in the cell or cells
with the format from the source. This is why you're losing your conditional
formats. You may want to try to PASTE SPECIAL. I'm not sure if you're
copying values or formulas, but jut make sure you're not copying the formats.
--
HTH,

Barb Reinhardt



"goodfish" wrote:

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

fear of a bug, hope for a workaround
 

yes i thought that might be happening however the formats are not replaced if
the range being pasted contains cf of its own
i cannot do paste values or formulas or anyother as far as i know because
all other cell formats (shading, borders, etc. all need to be copied)

"Barb Reinhardt" wrote:

IIRC, when you PASTE a range, you replace the formats in the cell or cells
with the format from the source. This is why you're losing your conditional
formats. You may want to try to PASTE SPECIAL. I'm not sure if you're
copying values or formulas, but jut make sure you're not copying the formats.
--
HTH,

Barb Reinhardt



"goodfish" wrote:

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