Sorry if this has been asked before, but is it possible and if so ho
can it be done to change the reference through VBA of a defined name
for instance, I have a list called 'People' and it resides on one of m
worksheets at $a10:$a60 and I want to be able to change the th
reference to say $a10:$a59 if I wanted to decrease the reference of th
list by one cell or alterantely if I wanted to increase by one cell t
$a10:$a61 if I wanted to increase the list size.

Thanks in advance

Henr

--
Message posted from http://www.ExcelForum.com