Hello,

I have an array of cells (A11:A18) where people can fill what program they want me to install to them with a VLOOKUP array of cells (B11:B18) where the price of the software license is displayed.
I would like to know if it is possible for me to auto add a list cell when the last cell of the array A11:A18 is filled so they can add more software to install.



Thanks a lot for helping,
Eli

Hi Eli,

It would be easier if you either:
a) defined the largest possible range that will be required; or
b) mark the last row in the range to indicate it shouldn't be used, then insert rows above that row as needed; or
c) assign a name to the range, use the range name in the formula and redifine the named range as need be

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]