A find and replace problem

Hello dear friends,
I have a workbook that has almost 98 worksheets. I need guidance on a problem. I want to find specific cells on these worksheets and change their values and again find some cells and change the value of the cell next to it. I use macro recorder to do that but it works on active cells and active worksheet only. I tried to do a loop to go through other worksheets and failed. Below is the code that i tried to create.

Please Login or Register  to view this content.

This works but only on active worksheet.

And my other question is, i am new to programming and vba. How can i learn this? I see some forum writers that write amazing codes. I know it takes time to learn that, but do i have to learn Visual Basic first? Because i have a lot of VBA e-books that many people say that those are good books. But i kind of feel that those books are incomplete. For example Code says "If range("a1:b5") is not....". How can i know that i can use "is not" in a code? And is there a complete list that VBA and Excel objects, methods and properties are explained? it can be a book suggestion about it...

Any help would be extremely appreciated.

Thank you,

Best Regards...

Thanks for the reply, maczaq;

i attached a sample file, mainly the cells with "green" bakcgrounds need to be changed. But if i see a sample working code i think i can manage the rest.

Thanks,

Regards.

Thanks for the reply, but when i copied your code it gives error.

Please Login or Register  to view this content.

Basically i want this to run on all worksheets. Any thoughts?

Thanks maczaq, first code seems to be working, second also works but not on some values, any way first one solves my problem, worst case i repeat that many times.
I owe you a dinner

What about my other question, i have no programming background, do i need to learn basic first, can you or someone reading this post recommend any books to learn VBA?
Thanks a lot again.

Best Regards.