I am confused about how to name a range. Do you mean naming a range 'total'
and then referring back to the formula where the value is = 'total' and the
column number is the active column number?
I am really new to this.
Thanks, Misty

Pranav Vaidya wrote:
I think then instead of using absolute row, column, you can try to use a
Named Range. Whenever, your total row changes, change the named range and I
hope it should work.

Thanks for your reply.
The row willl change as more employees are added and deleted. Do you know how
[quoted text clipped - 16 lines]

Thanks, Misty

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200709/1