Dynamic Range

[neilp]

Hi All

I have a sheet with named ranges. These are used on other sheets in data validation dropdowns.

I also have a small user form for people to add to one of the named ranges.

How would I go about making sure that the extra line gets captured in the named range.

For example, a list of cars in cells F2:F20 named "Vehicles". User adds another car via a userform which now appears in cell F21. how do I automatically capture it in the "Vehicles" named range?

Thanks in advance

Neil

 

[Scott T]

Create a dynamic named range.

http://www.excel-easy.com/examples/dynamic-named-range.html

 

[neilp]

Thanks Scott - all sorted now