So you want to the defined name ranges for a to l to change from row one to row 7? or just the single cell you have highlighted?

If you highlight row 7, and column C, you want C to point to row 7 instead of row 1? What about the rest of the named ranges, do they continue to point to row 1, or do they shift to row 7 as well?

Also, since there is no association between the defined named ranges, we will have to use some sequencial ID, just like your example a,b,c,etc...

Cal