Determine the row number and column number of a cell 1

[cojeda]

I have a macro used to locate a key word. I need to assign the row number and column number to variables after the macro finds the key word. How can I determine this?

Thanks,

Chris

 

[SkipVought]

Hi,

dim found as range, sFind as string
sFind = "key word"
set found = activesheet.cells.find(sfind)
if not found is nothing then  
  with found
    lRowFound = .row
    iColFounc = .column
  end with
else
  msgbox sfind & " not found"
end if

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[cojeda]

Thank you, that was perfect!