View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lonfnico[_2_] lonfnico[_2_] is offline
external usenet poster
 
Posts: 1
Default 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