Thanks that worked. But, now I'm not sure if I'm going about this the
right way. I want to use the formula as a named function and use that
as the source date of a chart I created. I'm trying to have the chart
update based on what the last row of data is, instead of just
arbitrarily using an ending row. So, instead of using something like
(=HeadCount!$A$2:$A$6) in the source data for the series, maybe it
would be (=HeadCount!TIME), if TIME was the name of the formula I was
orginally using. Not sure if this works like was orginally thinking.
Any ideas? THANKS