Please tell us what J6 though DJ represents.

It is not a range of cells. J6 is a cell and DJ is a column.

Maybe you meant J6 through DJ6

If you want to use Data Validation listrange dropdown, the cells must be in
one column, not across one row.


Gord Dibben MS Excel MVP

On Mon, 29 Sep 2008 12:15:02 -0700, Michelle
wrote:

I would like to insert a scroll bar which will allow me to scroll through a
range of cells. In other words, I have a range of dates from 9/2/08 through
12/15/08 in cells J6 through DJ and I would like to be able to scroll through
them using a scroll bar.

I have a template that contains this function, but I can't figure out how to
replicate it on my worksheet.
Thank you!