Name the list under InsertNameDefine.
Call it MyList.
Then in DV source dialog enter =MyList
Gord Dibben MS Excel MVP
On Fri, 5 Jan 2007 18:51:01 -0800, fLy wrote:
This sample:
http://www.contextures.com/xlDataVal10.html
used a list located in the same worksheet. I want to apply this on a list
that is located on another worksheet. What changes should I make?