to find the text and to know that particular cell address
 

I want to find the particular text in the report and I want to know the cell
address of that particular text. Please help me out.

to find the text and to know that particular cell address
 

set rng = cells.Find("The house is brown")
If not rng is nothing then
msgbox "rng.Address"
else
msgbox "Not found"
End if

--
Regards,
Tom Ogilvy


"cheenu" wrote in message
...
I want to find the particular text in the report and I want to know the
cell
address of that particular text. Please help me out.