Aju0652
01-27-2021, 09:41 PM
Hello All,
is there any Excel VBA code that should help me for find and replace? example i want to find "STD" in excel Sheet and then Replace it With "Division 1" after that next find "STD" and it would replace to "Division 2" and so on... for each STD find the replacement would be increment the Division Number Like "Division 3", "Division 4", "Division 5" and so on... until the last STD find. Please find the attachment for the refrence.
is there any Excel VBA code that should help me for find and replace? example i want to find "STD" in excel Sheet and then Replace it With "Division 1" after that next find "STD" and it would replace to "Division 2" and so on... for each STD find the replacement would be increment the Division Number Like "Division 3", "Division 4", "Division 5" and so on... until the last STD find. Please find the attachment for the refrence.