View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TBD TBD is offline
external usenet poster
 
Posts: 41
Default How to fake/simulate more than 256 columns

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!