have a look in vba help index for FIND and then FINDNEXT.

--
Don Guillett
SalesAid Software

"Ed" wrote in message
...
Hello, I would like to know if someone could help me out with a Macro, to
delete certain rows in certain Worksheets. Im working in a file that has
several Worksheets that work together. On column A of the Worksheets I
have a
certain reference which is a number. The idea is to have a 3rd Worksheet
to
control, for example to type in that control worksheet let's say in cell
A1 a
certain number and to run the Macro which would delete the rows in Sheet 1
and 2 containing that number in Column A.

thanks!