| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last cell in active row--I know, I'm sorry
Sub lastrow()
ActiveCell.End(xlUp).Select End Sub "Greg Snidow" wrote: Greetings all. I know this question has been asked here many, many times, but I can not get any of the examples to do exactly what I need. I need to select the last cell with data on the acive row. So, for example, if I have cell A1 selected, and there are data in cells A2, A5, and A8, I need a macro to select A8. If, then, I select B3, and there are data in B1, B3, and B10, I need it to then select B10. Any ideas? Thank you, and again, I apologize for the redundant question. Greg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
| run macro although blinking cursor is active in an active cell | Excel Programming | |||
| referring to formula in a non active cell from active cell | Excel Discussion (Misc queries) | |||
| I need to sort an active sheet using the col of the active cell | Excel Programming | |||
| Copy from active sheet and paste into new sheet using info from cell in active | Excel Programming | |||
Threaded Mode
