Finding cell address...

[korcutt]

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

[Chip Pearson]

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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[korcutt]

Thanks,

That did it...!

Kevin Orcutt