Certain cells in my workbook contains value 'A'. I want to replace the value 'A' with 'B'.
They scatter in several sheets. What is the most efficient way to implement the replacement in VBA?
This works for me
All I did was use the macro recorder to record a find and replace operation, then add the loops.
If you don't want to make the change in all open workbooks, remove the outer