View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal Robert Crandal is offline
external usenet poster
 
Posts: 309
Default 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??