Search range for value and change to a value

Hello everyone,

What would a macro look like if I wanted the macro to search a cell range for a value and then change the cell to a value. For instance lets say I would like a macro to search from A1:CD100 for the cell value Mic and change it to Michael. So if AD50 had the value Mic the macro would change it to Michael.

Thanks for the help.

Thanks,

Is it possible for the macro to automatically run whenever I change a cell value in that range or any range.

Thanks

Thanks!!

Is there a way to make it case insensitive. Essentially it would do the same thing for MIC, mic, Mic etc. I tried to search online for a way to do that but I turned up nothing.

Michael

Another:

Please Login or Register  to view this content.

Works for all variations.