Excel has a limit of 256 columns, but for rows it is only
limited by the amount of hard drive space that you have.
Robert was speculating that you are trying to use a column
for each day of the year, therefore needing 365 columns
(Though don't forget that in 2004, there are 366 days,
it's a leap year) if in fact you are trying to get enough
columns to equal a day.

So, the question he was asking, was do you currently have
more than 256 rows, or expect more rows than that, and
could you transpose your data, doing something like the
following:

Original data

A B C D
1 2 3 4
2 3 4 5

Look like this
A 1 2
B 2 3
C 3 4
D 4 5

If you currently have less than and expect to always have
less than 256 rows then you could do the transpose and get
all of your data in one workbook. Otherwise you may have
to span the data over multiple workbooks, which in itself
can get tricky... If you edit code in one of the
workbooks, you have to make the same edit in the other(s).


-----Original Message-----
Sorry, not sure what you mean here Robert ?


"Robert McCurdy" wrote in
message
...
One column per day Amit?
How many rows are you using?


Regards Robert

"Amit Shanker" wrote
in message
...
This is not possible.

Amit


"Jack" wrote in
message
...
Hi...

I'm using office 2003 - anyone know how I can
extend the
limit of columns that currently stops at column IV.
I need
365 colums so need many more columns.

Thanks in advance...

Gordon




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system
(http://www.grisoft.com).
Version: 6.0.551 / Virus Database: 343 - Release Date:
11/12/2003




.