| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding the last cell in a series
How do you find the last cell in a series i.e. in a column? I have heard that
there is a simple command that does it but I dont know what it is. Please help me! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Finding the last cell in a series
Dim lastCell as Range
Dim col as Long Col = 5 Set lastcell = Cells(rows.count,col).end(xlup) msgbox "Last used cell in column E is " & lastcell.Address -- Regards, Tom Ogilvy "Arne Hegefors" wrote: How do you find the last cell in a series i.e. in a column? I have heard that there is a simple command that does it but I dont know what it is. Please help me! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding next number in a series | Excel Worksheet Functions | |||
| Finding series index if I know the Series Name | Charts and Charting in Excel | |||
| finding chart series low | Excel Programming | |||
| Finding a series of values within an Array | Excel Programming | |||
| Finding a series of values within an Array | Excel Programming | |||
Linear Mode
