find row index

[crew3407]

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

 

[Stephan Kassanke]

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

the find method results in a range object.

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

You can assign myresult.row then to your variable.

cheers,
Stephan

 

[Bernie Deitrick]

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

 

[Bob Phillips]

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]

thanks guys, appreciate i