Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding a cell, selecting the one down
Everything is in the title! I have a table of unknown length, I can find it because we have a keyword as the title of this table in my sheet. I found out how to select the whole table down (using Range(Selection, Selection.End(xlDown)).Select). But my problem is really basic... I don't want to select the title, so I would like the active cell to be the one just DOWN the one I found in my sheet. Actually, my question is so basic, that I have too many answers on the forums, I just cant sort out what is what I'm looking for. Thanks in advance PS: as a generic question, is there something like -Cells.Next("direction", value).Activate- to navigate through cells? -- lonfnico ------------------------------------------------------------------------ lonfnico's Profile: http://www.excelforum.com/member.php...o&userid=33396 View this thread: http://www.excelforum.com/showthread...hreadid=532186 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting a cell entry based on cell validation selection | Excel Worksheet Functions | |||
Help for Macro: Finding last cell and selecting it | Excel Discussion (Misc queries) | |||
Finding a minimum value and selecting the cell containing this val | Excel Worksheet Functions | |||
finding ROW without selecting worksheet | Excel Programming | |||
Finding and Selecting Specific Ranges | Excel Programming |