I've read that in the next version of Excel, there will be 1.1 million rows.
Now one of the most common methods to find the last row is:

lastRow = Cells(Application.Rows.Count, 1).End(xlUp).Row

Counting 1.1 million rows will take a longer time than counting 65,336 rows.
So will the above still be good technique?

Hi Shatin,

Counting 1.1 million rows will take a longer time than counting 65,336 rows.
So will the above still be good technique?

I don't think it will make much of a difference.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

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?


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. I never
fill an excel sheet with data without knowing how many records there
are and in what cell I am at the moment, so I never needed to use these
"guess where the file ends but please treat empty cells correctly"
functions. But that's only my opinion, and for sure, I am totally wrong
;)

arno

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/

Probably the most common question the Excel team gets from our customers is
"when are you going to add more rows/more columns/more rows and more
columns". There are many different scenarios behind these requests. Some
customers want to be able to analyze more data than Excel has rows, some
customers want to track more daily information than Excel has columns, and
other customers want to perform matrix math on large matrices of thousands
of elements. There are plenty of other scenarios too. Well, the answer to
the question is "in Excel 12." Specifically, the Excel 12 grid will be
1,048,576 rows by 16,384 columns. That's 1,500% more rows and 6,300% more
columns than in Excel 2003, and for those of you that are curious, columns
now end at XFD instead of IV.

"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

Thanks for the links!

I already asked my favorite question...
(when will password protected projects be password protected)

arno
:)

It should be.

--
Regards,
Tom Ogilvy

"Shatin" wrote in message
...
I've read that in the next version of Excel, there will be 1.1 million
rows.
Now one of the most common methods to find the last row is:

lastRow = Cells(Application.Rows.Count, 1).End(xlUp).Row

Counting 1.1 million rows will take a longer time than counting 65,336
rows.
So will the above still be good technique?