This might be an obvious question but can a list within an addin be referenced from a worksheet to populate a validation list? I cannot figure out the correct formula to place in the validation list for the lookup. I am trying to use a named range within the addin - maybe that is the problem.