View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gareth[_3_] Gareth[_3_] is offline
external usenet poster
 
Posts: 109
Default Setting up data validation lists

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