"arno" skrev i melding
...
Hi Shatin,

I've read that in the next version of Excel, there will be 1.1
million rows.
where did you read this? can you post a link?

http://blogs.msdn.com/excel/default.aspx

Now one of the most common methods to find the last row
is:
Personally, I do not like all this xlup/down-and-wherever stuff.
Either you know where you are/how many records you have or not.

It is for use in the "not" cases. Pretty useful actually, you can write code
that works for multiple different files..

HTH. Best wishes Harald