Replace Multiple Values|VBA & Macros|Excel Forum|My Online Training Hub

Hi,

Attached macro work to replace Column I values by Column J in Column A

Ex: 

Column A: Ándre Oliveira

Column I: á

Column j: a

So macro result is andre Oliveira

Please I want to add character sensitive in macro, to don't replace small characters by upper characters or upper characters by small characters.

So in above case, the macro result will be Ándre Oliveira without any change.

Please check attached macro.

Thanks;

Marsil