Casey Crookston wrote: >How do you specify that C15 is to remain unchanged? > > use $C$15 use a $ before the row/column ID to fix that cell row/column when transfering the formula with copy/paste