PartsLists is a defined name.
to change what the name refers to use:

insert/ name/ define...

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


ricksimm wrote :


I am using a data validation list defined as a range using
=PartsList. If the range was initially set up as A1:A10 and I change
the range (delete the data in A4), is there some way in VBA that I
can adjust the size of the range to now be A1:A9 so that I can
continue to use the =PartsList for validation? Thanks.