Hello,

Quick question, I was just wondering how you find the row index of
cell that i found using find and then storing that into a variable.
need to reference information in that row. Thank

--
Message posted from http://www.ExcelForum.com

"crew3407 " schrieb im Newsbeitrag
...
Hello,

Quick question, I was just wondering how you find the row index of a
cell that i found using find and then storing that into a variable. I
need to reference information in that row. Thanks


---
Message posted from http://www.ExcelForum.com/


the find method results in a range object.

set myresult = .find(.....)

You can assign myresult.row then to your variable.

cheers,
Stephan

Crew,

Try something like

Dim myRow As Long
Dim myCell As Range

Set myCell = Cells.Find(.......)
If Not MyCell Is Nothing Then
myRow = myCell.Row
End If

Then myRow can be used like

Cells(myRow,3).Value = "This is entered into column C"

HTH,
Bernie
MS Excel MVP

"crew3407 " wrote in message
...
Hello,

Quick question, I was just wondering how you find the row index of a
cell that i found using find and then storing that into a variable. I
need to reference information in that row. Thanks


---
Message posted from http://www.ExcelForum.com/

Activecell.Row

or

Range(myvar).Row

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"crew3407 " wrote in message
...
Hello,

Quick question, I was just wondering how you find the row index of a
cell that i found using find and then storing that into a variable. I
need to reference information in that row. Thanks


---
Message posted from http://www.ExcelForum.com/

thanks guys, appreciate i

--
Message posted from http://www.ExcelForum.com