| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 12 - finding the last row
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel finding top of range | Excel Discussion (Misc queries) | |||
| Finding 2 or more words in excel | Excel Discussion (Misc queries) | |||
| EXCEL 2003 IS NOT FINDING MY EXCEL 2000 FILES FROM A CD | Excel Discussion (Misc queries) | |||
| Finding a function in Excel | Excel Worksheet Functions | |||
| Finding an Excel value using one repeating & another value? | Excel Worksheet Functions | |||
![Shatin[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
