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?? |
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?? |
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?? |
All times are GMT +1. The time now is 12:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com