That is exactly what I want. I want C25:c111 ot become c25:c112 soit lengthens the range of the formula. It should not just move therange down one. The other two require the range to shorten.