Look at Find and FindNext in VBA help.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

wrote in message
ups.com...
Hi,

I need to find the word books then go three columns along and multiply
the cell value by 2.

the macro should then look for every occurence of the word books and
do this,

if the word books is not found I'd like it to continue to the next
part of the macro......


I appreciate your help,

thanks so much,

im too old to learn this but you all saved me alot of time in my work,

Andrea