Dynamic Name Range

B

Bob Phillips

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

as an example

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top