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

<(E-Mail Removed)> skrev i melding
news:(E-Mail Removed)...
> 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...
>

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".



In article <(E-Mail Removed)>,
(E-Mail Removed) wrote:

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

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.



(E-Mail Removed) wrote:
> 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...
>

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 Removed)
Replace @mailinator.com with @tiscali.co.uk


"Harald Staff" <(E-Mail Removed)> wrote in message
news:OLkgaP7$(E-Mail Removed)...
> 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
>
> <(E-Mail Removed)> skrev i melding
> news:(E-Mail Removed)...
>> 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...
>>
>
>
>

"Sandy Mann" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> It's good to see you back in the English Newsgroups Harald, hope you stick
> around more.

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

Welcome back Harald.

As Sandy said.................long time no see.


Gord

On Wed, 26 Sep 2007 20:36:53 +0200, "Harald Staff" <(E-Mail Removed)> wrote:

>"Sandy Mann" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed)...
>> It's good to see you back in the English Newsgroups Harald, hope you stick
>> around more.
>
>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" <(E-Mail Removed)> wrote in message
news:eYzj$(E-Mail Removed)...
> "Sandy Mann" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> It's good to see you back in the English Newsgroups Harald, hope you
>> stick around more.
>
> 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


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.

--
Regards
Roger Govier



"Harald Staff" <(E-Mail Removed)> wrote in message
news:eYzj$(E-Mail Removed)...
> "Sandy Mann" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> It's good to see you back in the English Newsgroups Harald, hope you
>> stick around more.
>
> 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

Hi,

> Anyone notice that there are only 65536 (which is one higher than the
> magic 65535) rows allowed in older versions of Excel?

http://blogs.msdn.com/excel/archive/...26/474258.aspx

explains expanded limits between 2003 and 2007 en detail

--
mit freundlichen Grüßen aus Nürnberg

Klaus Oberdalhoff (E-Mail Removed)
Ich unterstütze PASS Deutschland e.V. (http://www.sqlpass.de)
Nächstes Treffen in Nürnberg am 23.10.2007