Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hope someone can help me | Excel Discussion (Misc queries) | |||
Hope Someone Can Help... | Excel Programming | |||
Last Hope -HELP!! | Excel Programming | |||
Last Hope -HELP!! | Excel Programming |