How does one define a Name that automatically updates its rang
reference for a Lis

--
RJB0
-----------------------------------------------------------------------
RJB02's Profile: http://www.excelforum.com/member.php...fo&userid=3438
View this thread: http://www.excelforum.com/showthread.php?threadid=54167

=OFFSET($A$1,,,COUNT($A:$A),1)

as an example

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"RJB02" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> How does one define a Name that automatically updates its range
> reference for a List
>
>
> --
> RJB02
> ------------------------------------------------------------------------
> RJB02's Profile:
http://www.excelforum.com/member.php...o&userid=34385
> View this thread: http://www.excelforum.com/showthread...hreadid=541670
>