Can you transpose your rows and columns? If you're not showing it to the user,
your code could just do things "backwards" <vbg.

Can you upgrade to xl2007 (with 1 million rows and 16k columns)?

If no to both, then maybe you could reserve two columns to act as a key.

The first column is the key for that record. The second column is just a
counter of which row you're on for that record. You'll have to map your fields
(column E of Row 2 for employee 12345 record).

But that's pretty much as multiple sheets.

You may to consider using a userform to show the info/get input from the user.

You could look at John Walkenbach's enhanced data form:
http://j-walk.com/ss/dataform/index.htm

The source code is available for a small fee ($20 USA, IIRC). So you can modify
it as much as you want.

tbd wrote:

Greetings,
I'm using an Excel spreadsheet to define and maintain a data-set used
by another application. So, the spreadsheet is a "UI" where users' control
over sheet is limited.

The data represents a "daily schedule" where the user contols how many
days are defined. The right-most column represents the last day defined by
the schedule. It's reasonable to expect a schedule will (need to) define
more than 256 days (columns).

I'm considering maintaining a data-set on another sheet, or in a
disk-file, and just populate the UI according to what user wants to see. For
instance, maybe up to 60 columns are used, and when the user wants to see a
61st day, the data is programmatically "scrolled" to the left such that
column 60 holds day 61, and column 1 holds day 2. Of course it would be nice
to employ the standard worksheet scroll-bars, but if I have to manage one, so
be it.

If anybody [is not completely confused by now, and] has tried anything
like this, or if you have any enlightening ideas, I'd be interested in
hearing from you.

Thanks/Cheers!

--

Dave Peterson