Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel limits question
I see that Excel's limits for a sheet are 65,536 rows and 256 columns.
Does this mean I can't have 1 row with 650 columns?? I was planning to use the following code: For N = 1 to 650 Cells(1, N).Value = N Next N I tested this code and seemed to work okay. I'm just curious why the specs say 256 colums is max, yet I managed to fill in cells (1,1) to cells (1,650) with values?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel limits question
excel 2003 - 65536 rows -256 columns
excel 2007 - Worksheet size 1,048,576 rows by 16,384 columns -- Gary Keramidas Excel 2003 "Robert Crandal" wrote in message ... I see that Excel's limits for a sheet are 65,536 rows and 256 columns. Does this mean I can't have 1 row with 650 columns?? I was planning to use the following code: For N = 1 to 650 Cells(1, N).Value = N Next N I tested this code and seemed to work okay. I'm just curious why the specs say 256 colums is max, yet I managed to fill in cells (1,1) to cells (1,650) with values?? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel limits question
Run this code and all will be revealed:
Sub test() MsgBox "Row number: " & Cells(650).Row & vbCrLf & _ "Column number: " & Cells(650).Column, , _ "Cells(650)" End Sub RBS "Robert Crandal" wrote in message ... I see that Excel's limits for a sheet are 65,536 rows and 256 columns. Does this mean I can't have 1 row with 650 columns?? I was planning to use the following code: For N = 1 to 650 Cells(1, N).Value = N Next N I tested this code and seemed to work okay. I'm just curious why the specs say 256 colums is max, yet I managed to fill in cells (1,1) to cells (1,650) with values?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel limits | Excel Programming | |||
Limits of Excel | Excel Programming | |||
Excel 2007 question - row and column limits | Excel Discussion (Misc queries) | |||
Limits of excel | Excel Discussion (Misc queries) | |||
Excel Tab limits | Excel Discussion (Misc queries) |