This is my scenario:

I’m using Excel 2003 and I need a macro to find a character in a colum
(I) and then if its found select columns (A to G) in that same row.
need to repeat this for all instances within the workbook. Th
character in column (I) will always be a single character such as E o
M. Basically, I want to copy the selected cells and copy them int
word. Please help if someone can.

Scot

--

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