Hello Brettjg,

Not possible using Data Validation. You can do it by placing a Forms
Toolbar Drop Down or Controls Toolbox ComboBox (ActiveX control) on the
worksheet and writting the macro code to do both the validation and
extending the number drop down of lines.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=551733