Replacing texts and cases

[tsgucci]

Hello Guys!


This is my first post here! I'm from Hungary and I'm an excel freak


I've an excel file, in column "A" I do have texts (approx 120 lines) which I would like to replace by column "B". I've created the macro, which loops line by line and replace the cell A by cell B on a second sheet where hell of texts are. The macro works fine but I would like to add a function. I would like to know how many times the macro replaced that particular text and I would like to the macro that it is writing the number in cell C. Is it possible somehow?

Thanks for you replies in advance!

[JBeaucaire]

That's pretty easy to do, the exact code would be affected by your current macro. Post your current macro and we can offer an exact solution. As per forum rules, be sure to post your code in code tags, like so:

Please Login or Register  to view this content.

[tsgucci]

Thanks!


Here is my code:

Please Login or Register  to view this content.

[tsgucci]

Hello Guys!

Can you help me?

[JBeaucaire]

Sorry, holidays....

Something like this with no unnecessary "selecting":

Please Login or Register  to view this content.

[tsgucci]

Thanks, but this is only a replace code. I would like to see how many times the macro replaced an object.

Thanks!