Hi All,
I have the following code.
Code
Cells.Replace What:=ActiveSheet.Name & "!", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
If I do a standard Find & Replace then excel will display a msgbox displaying the number of replacements made. I'm struggling to figure out the VBA needed to count the number of replacements so that I can put a msgbox together to alert the user of the number of replacements made.
Appreciate any help given on this topic.
Kindest regards,
Jon