Hi,

Excel 2002.

I like the Data Validation with the list option but I have come across
two problems with the way I want to use it.

1. The source reference cells must be on the same sheet as the data
entry cell(shame!).
2. After creating the validation rules, if I add an extra entry to my
array, I need to go back to the Data / Validation option and update
the value to include the new entry.

I can get round 1 by copying the table from Sheet2 to Sheet1 (not
ideal solution though).

I cannot see how to update the validation rules in VBA. I've looked at
the object model but cannot see what I need to update - if I can at
all.

Basically, I have Sheet2 where there is a list of companies. Users can
update this list at will.

On sheet1 I want them to enter data and only enter valid company names
(hence Data / Validation). However, when new companies are added they
need to be copied to Sheet1 then, somehow, I need to update the Data /
Validation programatically. How can I do this?

Is there are better way to do this than use the Data / Validation
route?