Dim rng as Range, rng1 as Range
set rng = columns(3).Find("searchterm")
if not rng is nothing then
set rng1 = rng.offset(0,10)
msgbox rng1.address
End if

this would give a reference to column M, same row as the searchterm was
found

as an example.

--
Regards,
Tom Ogilvy


"licy" wrote in message
...
how do I get reference to a column after I find a match in a different
column