excel VBA

[Guest]

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

 

[Chip Pearson]

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

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

different column

 

[Tom Ogilvy]

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

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

column