Setting up data validation lists

G

Gareth

I need to set up two lists in one column.

When the user gets the file it contains data, he will add data to it. I
want one list for the original data and another for 200 additional rows.

I use the following to add the first list but have not been able to modify
it so that list 2 can be added.

Sub enterDV()
Range("F2:F" & Range("F" & Rows.Count).End(xlUp).Row).Validation.Add
Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=
Formula1:="mylist1"
End Sub

I have tried offset but really haven't a clue how to go about it.

Thanks in advance

Gareth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top