RE: Data Transfer

Wouldn't [CTRL][DOWN] do the same thing?

Loyd

-----Original Message-----
From: Mike Naughton [mailto:mnaughton@juddwire.com]
Sent: Friday, September 06, 2002 10:31 AM
To: MIDRANGE-L@midrange.com
Subject: RE: Data Transfer


> According to Microsoft Technet, the
maximum number of rows in Excel 97 is 16,384.

I know this was true for earlier versions of Excel, but I just checked -- I
seem to be using MS Excel 97 SR-1, and my row limit is definitely 65,536.

(You can do a simple test - just  open a new spreadsheet and write a macro
such as the following:

Sub OverFill()
    Range("A1").Select
    C = 0
    Do
        C = C + 1
        ActiveCell = C
        ActiveCell.Offset(1, 0).Select
    Loop While C < 1000000
End Sub

then run it. It will break when it reaches the last row. . . .)

HTH


Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@juddwire.com