I've inherited a workbook with some 100 or so defiined names, each of them
tailored to refer to vertical single-column ranges in different sheets in the
workbook. At some point I'll just recreate the whole thing to eliminate many
of the names, but for now I need to change the range references to all of
them so the final row is the same (row 1000). Is there a quicker way to do
this than manually changing the reference to each in the "Define Names" box?

Help!