Hi, I am new at this stuff but I think this should do it.

Rgds,
Ozgur

Sub Find()
Dim AAA As String
Dim BBB As String
Dim CCC As Long

AAA = ActiveCell.Address
BBB = Mid(AAA, 2, 1)
CCC = Mid(AAA, 4, 5)
Cells(CCC + 1, BBB).Select
Range(Selection, Selection.End(xlDown)).Select
End Sub

"lonfnico" wrote:


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