How do I use this code segment to validate Cell C3 using the name range
"Vendor_List" on worksheets("Vendors")?

With Range("C3").Validation
.Add xlValidateList, xlValidAlertStop, xlBetween, "=$A$1:$A$10"
.InCellDropdown = True
.IgnoreBlank = False
End With