Simon,

I only what to search in one column which is "I". Then if "E" or "M" i
found in that column then I want to Select columns "A to G" in that sam
row. But I want to do this to the entire sheet with one click becaus
there are multiple instances within a workbook. I thought of using a I
statement and narrow the search only to column "I". Thanks for th
help.

Scot

--

-----------------------------------------------------------------------
's Profile: http://www.excelforum.com/member.php...fo&userid=1627
View this thread: http://www.excelforum.com/showthread.php?threadid=27684