"Tendresse" wrote:

hi all, i'm stuck and need some help, please.
How do you say the following in VBA?

In range("C15:C100"), find the cell that contains the value 'IDNumber' and
select the entire row where this cell is, and extend the selection to include
the following 9 rows below the cell. If the IDNumber not found, prompt the
user that number not found.

Is this a homework assignment?

What have you tried? Maybe somebody can point you to the thing you should
look at.

Peter Richardson