You probably did not modify to fit YOUR situation.
Did you use cell a2 to type in the name Joe or Bill?
Do you have a sheet2 and a sheet10?

--
Don Guillett
SalesAid Software

"MBlake" wrote in message
...
Hi,
Many thanks for your assistance. I added the code to the worksheet object
and saved file but nothing. Do you know where I can find a tutorial on
this
aspect of Excel?.

Thanks again,
Mickey