View Single Post
  #2 (permalink)  
Old March 4th, 2008, 08:14 PM
stanleydgromjr stanleydgromjr is offline
Authorized User
Points: 193, Level: 3
Points: 193, Level: 3 Points: 193, Level: 3 Points: 193, Level: 3
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2007
Location: North East Pennsylvania, USA.
Posts: 48
Thanks: 0
Thanked 4 Times in 4 Posts
Default

cronid,

To be able to access all the rows in:
Excel 2003 contains 65,536 rows.
Excel 2007 contains 1,048,567 rows.

Integer variables are stored as 16-bit (2-byte) numbers ranging in value from -32,768 to 32,767.

Long (long integer) variables are stored as signed 32-bit (4-byte) numbers ranging in value from -2,147,483,648 to 2,147,483,647.

I would change this line of code:
Dim rwIndex As Integer

to this:
Dim rwIndex As Long


Have a great day,
Stan

stanleydgromjr

Windows Vista Business and Excel 2003, 2007.
Reply With Quote