Can you expand on the rules governing how this is supposed to work? Is the
"text" you are looking for always going to be a number as your two examples
show, or will other text be involved? What governs the the range T:AH is to
be copied to (your example has two consecutive values being found in the
same column, but getting mapped ranges that are not consecutively offset
from AI)? Remember, we do not know anything about your set up and what you
want to do with it unless you tell us.

--
Rick (MVP - Excel)


"Outatym" wrote in message
...
I need some VBA code to search the contents of column AI for certain text,
then if found copy that row's range T:AH and paste it elsewhere. For
instance if "3" is found in T it will need to be pasted into AI:AW. If
"4"
is found in T then the same range (T:AH) will need to be pasted into
AL:AZ.
And so on...

I know this is easy, but having a hard time getting it to work.

Thanks!
Chris