| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find the last Cell in a column in VB
Or more simply:
LastRow = range("C:C").SpecialCells(xlCellTypeLastCell).Row regards |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find the last Cell in a column in VB
Which is not reliable if used range has not been re-set.
Enter data in column C down to row 100 then run the code which will return 100 lastrow = Range("C:C").SpecialCells(xlCellTypeLastCell).Row MsgBox lastrow Clear Contents from C51:C100 then run again. You still get 100 Gord Dibben MS Excel MVP On Thu, 11 Dec 2008 13:54:12 -0800 (PST), Coder1215 wrote: Or more simply: LastRow = range("C:C").SpecialCells(xlCellTypeLastCell).Row regards |
| Reply |
| 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 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 Programming | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| Move Cell in Column A to Column B when FIND | Excel Programming | |||
Linear Mode
