Rows Limit in VBA Macro

[coolzero]

Hello guys,

Just a quick question: Why does in VBA Macro there's a limit in rows? just upto 32000+ rows. Well in fact, we can see that in Excel2007 the rows could reach upto 1M. What should be done to avoid this? Im using "integer" as the variable.


Thanks.

[royUK]

You can't use Integer as the variable, you must use Long

Please Login or Register  to view this content.

[teylyn]

Hello,

by definition Integer variables can hold values between -32,768 and 32,767. If you need to store larger numbers, use Long, which can range from -2,147,483,648 to 2,147,483,647

cheers,

[coolzero]

This would be of great help!

Thanks a lot!!!