Finding cell address...
 

Howdy all,
I am trying to get the row index of a cell in a column that has some
particular text in it... For instance. In column A, I know there is a
cell with the text: "*CAPTURE.DATA" in it. How do I programmatically
get the row index of that cell? What I really need is the index of the
net row where that data really starts....

Thanks in advance, for helping a excel newbie!

Kevin Orcutt


--
korcutt
------------------------------------------------------------------------
korcutt's Profile: http://www.excelforum.com/member.php...o&userid=28632
View this thread: http://www.excelforum.com/showthread...hreadid=482938

Finding cell address...
 

Try something like

Dim FoundCell As Range
Set FoundCell = Range("A:A").Find(what:="*CAPTURE DATA",
LookIn:=xlValues, lookat:=xlWhole, MatchCase:=False)
If Not FoundCell Is Nothing Then
MsgBox "Found at row: " & FoundCell.Row
Else
MsgBox "Not Found"
End If




--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"korcutt"
wrote in message
...

Howdy all,
I am trying to get the row index of a cell in a column that has
some
particular text in it... For instance. In column A, I know
there is a
cell with the text: "*CAPTURE.DATA" in it. How do I
programmatically
get the row index of that cell? What I really need is the
index of the
net row where that data really starts....

Thanks in advance, for helping a excel newbie!

Kevin Orcutt


--
korcutt
------------------------------------------------------------------------
korcutt's Profile:
http://www.excelforum.com/member.php...o&userid=28632
View this thread:
http://www.excelforum.com/showthread...hreadid=482938

Finding cell address...
 

Thanks,

That did it...!

Kevin Orcut

--
korcut
-----------------------------------------------------------------------
korcutt's Profile: http://www.excelforum.com/member.php...fo&userid=2863
View this thread: http://www.excelforum.com/showthread.php?threadid=48293