I am working in xlsx (Excel 2007) and working with a range, long 260k rows. I declared a counter as "long" to determine the range size. Msgbox returns the correct 260k. I can go to the end of the range, so row 260k ... Now I want to work my way up line by line by using:
But Excel returns an overflow error message.
Please Login or Register to view this content.
Any suggestion ?
Last edited by JBeaucaire; 11-28-2013 at 02:55 PM.
Where is the error occurring?
If posting code please use code tags, see here.
There's no reason based on the information given so far for that error. Perhaps a look at the whole macro.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Please Login or Register to view this content.
Last edited by Leith Ross; 11-28-2013 at 06:03 PM. Reason: Added Code tags
For the future: Use code tags around code.Please Login or Register to view this content.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks