I have a worksheet with four columns -

Total Hours
Percent to total Hours
Value of Hours
Percent to total Value of Hours

The row with the total varies, so in my macro I have named the row with the
total TOT_HOURS (=a and whatever the last row is)

In column B, on each row, I perform the calc b1/tot_hours, etc., to get the
percent to total.

How could I make tot_hours relational, that is, when I copy the formula to
column d, have tot_hours refer to column c instead of column a?

Just copying the formulas doesn't work.