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
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