65536

  • Thread starter Thread starter ljpj707
  • Start date Start date
L

ljpj707

Anyone notice that there are only 65536 (which is one higher than the
magic 65535) rows allowed in older versions of Excel? Mabe there's
some rogue GOTO statement in the row attributes section of the code...
 
Both my Excel 97 and my Excel 2003 (and versions between) has 65536 as a
last row. 65536 is 2^16 , a nice round binary number.
Excel 95 down and Excel 2007 up have different limitations.

HTH. Best wishes Harald
 
Anybody over a certain age that ever programmed in hex or binary
certainly recognizes 65536 as 2^16.

And while the problem is very likely related to that number, it almost
certainly has *nothing* to do with "row attributes".
 
If you start numbering at 0, the largest number representablin in binary
with 16 digits you can display is 65535,
but you still can display 65536 numbers. So if internally you number the
first row with 0, you hac have 65536 rows numbered from 0 to 65535.

The same issue occurs when using either INDEX or OFFSET in Excel.
 
It's good to see you back in the English Newsgroups Harald, hope you stick
around more.

--
Rergards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Sandy Mann said:
It's good to see you back in the English Newsgroups Harald, hope you stick
around more.
Click to expand...

This is the nicest thing I've ever read, Sandy. Thank you thank you.
I took a break from Excel and online communites when 2007 beta came.
Resulting in a miserable professional life without any fun things to do.
Trying to catch up now and learn the new version.

Best wishes Harald
 
Harald Staff said:
This is the nicest thing I've ever read, Sandy. Thank you thank you.
I took a break from Excel and online communites when 2007 beta came.
Resulting in a miserable professional life without any fun things to do.
Trying to catch up now and learn the new version.

Best wishes Harald
Click to expand...


Come on Harald, nicest thing you've ever read? I'm sure reading about all
those tons of Norwegian OL golds were more fun? <vbg> Welcome back Harald.

Peo
 
Hi Harald

Add my good wishes to the others.
It's definitely good to see you back here.
 
Back
Top