how do I get reference to a column after I find a match in a different column

Your question isn't very clear. Perhaps you could provide a few
more details.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


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

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