Hi Keith,

Yes, you can definitely use a column in a named table as your data validation list without specifying the range. Here's how you can do it:

1. Select the cell where you want to apply the data validation.
2. Go to the Data tab and click on Data Validation.
3. In the Data Validation dialog box, select List from the Allow drop-down menu.
4. In the Source field, enter the following formula:
   Code:

   =MyTest[Name]

5. Click OK.

This will create a data validation list based on the values in the Name column of your MyTest table. The formula refers to the entire column of Name in the MyTest table, so you don't need to specify a range.