View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
COM COM is offline
external usenet poster
 
Posts: 40
Default 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.