Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extend Excels range
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extend Excels range
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extend Excels range
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extend Excels range
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extend Excels range
I'm guessing that Robert wants the OP to transpose his data. But only if he's
using using fewer than 257 rows. Amit Shanker wrote: 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 -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extend Excels range
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 . |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extend Excels range
COM wrote:
Excel has a limit of 256 columns, but for rows it is only limited by the amount of hard drive space that you have. Wrong, AFAIK Excel has limited rows and columns (256x65536?). Worksheets are limited by the amount of memory. Regards, -- Beto Reply: Erase between the dot (inclusive) and the @. Responder: Borra la frase obvia y el punto previo. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extend Excels range
I stand corrected. Never gone as far as 65536 rows... Hope I never have to control that many locations. On a philosophical note, it looks like the max number of rows is determined by the size of Integer where Integer starts at the value of 1, vice the value of 0. So, if Integer is ever declared as a larger value, based on the number of bits in the operating system, then perhaps the number of rows could be increased by that number. But then again, don't know how Microsoft encoded the lower and upper limits, and if they would ever change those limits, because of trying to maintain legacy compatability.
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extend Excels range
Dear Jack
assuming you want to build something 'over a Year', then try to make a monthly breakdown and use 12 Sheets to hold Data, as we all have to. Heiko "Jack" wrote: 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 |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extend Excels range
Jack wrote:
*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 * Hi Jack, If you really need more than 256 column, it can be done with the Spreadsheet Control (part of the Web Office Components) Here is a sample file:) Attachment filename: spreadsheet.xls Download attachment: http://www.excelforum.com/attachment.php?postid=390354 --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to extend the active range | Excel Discussion (Misc queries) | |||
Extend Name range | Excel Discussion (Misc queries) | |||
HOW TO EXTEND A NAMED RANGE | Excel Worksheet Functions | |||
Painting Range - extend the range on the top part | Excel Discussion (Misc queries) | |||
Extend a data range | New Users to Excel |