Sub SEHrow()
Dim rFound As Range
Set rFound = ActiveSheet.UsedRange.Find("SEH", , , xlWhole)
If rFound Is Nothing Then
MsgBox "Not Found"
Else
MsgBox "Found at Row #" & rFound.Row & _
" Column #" & rFound.Column
End If
End Sub

HTH
--
AP

"Chaplain Doug" a écrit dans le
message de news: ...
Excel 2003. I have a cell labeled "SEH." I want to be able to determine
in
which row of the spreadsheet this Cell resides and to use that number
programmatically. This row is not in a fixed position (as my code inserts
a
variable number of rows above this row). How may I get this labeled
cell's
row number? Thanks and God bless for the help.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org