Excel limits question

[Robert Crandal]

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??

 

[Gary Keramidas]

excel 2003 - 65536 rows -256 columns
excel 2007 > - Worksheet size 1,048,576 rows by 16,384 columns

 

[RB Smissaert]

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