| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find last used cell in an column
Hi
What is the best way of finding the last used cell in a column? At the moment i use: While Len(i_workSheet.Range(i_sColumn & CStr (i_iIndex)).value) 0 i_iIndex = i_iIndex + 1 Wend GetLastUsedRowInColumn = i_iIndex Yours sincerly /Niklas |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches | Excel Worksheet Functions | |||
| Find cell address of last cell in a column with text | Excel Worksheet Functions | |||
| Find max value in one column and return the value of corrosponding cell in different column | Excel Worksheet Functions | |||
| find first empty cell in column and start transpose next row in that cell | Excel Discussion (Misc queries) | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
![Niklas[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
