I have a formula in say column D & have copied it across to various other columns, the thing is is that the copied cells do not have the same formula as in cell D (it adds a column instead of copyin the formula) thank you in advance