Do you also want the next 456 to receive "hold" in column B and the next 789 to
receive "clear" in column B.


Gord Dibben MS Excel MVP

On Sun, 10 Feb 2008 12:28:11 +0100, "MicrosoftNews" wrote:

Hi all,

please help me by solving the folowing problem...
I want to check a sheet with four columns
---------------------------------------------------
-A- -B- -C- -D-
123 active 1,2 3,0
456 hold 2,4 4,2
789 clear 5,7 3,6
123 3,9 2,4
123 1,7 8,4
789 9,4 4,3
456 4,3 2,8
---------------------------------------------------

now I want to check column -A- for "123"and fill the column -B- with the
value "active" for the following rows.

How can I do this by vba ?????

Many thx in advance.

greetings joachim