findandreplace

  1. S

    Find and Replace Suffix Macro

    All, I am trying to remove common company suffix names from a large dataset and the code I have below works to an extent but I am hoping to get some help to clean up the code and make it a little bit more user friendly. I am hoping to replace the s1 array with a defined table (on Suffix tab...
  2. M

    Excel VBA modifying Word document Header & Footer

    Good Afternoon, I'm trying to modify my current code to replace specified words in a MS Word document. The whole idea is working but only for the body of the document and nothing happens in the header neither in the footer. Can you please advise me where am I wrong ? Thank you in advance...
  3. D

    Find Next button fails to find records

    I have two membership type databases (they are in no way connected, I mention both for illustrative purposes) Both use a form to input data, the control source for each form is a query and each query updates respective tables. In both databases, there is a Command Button the purpose of which...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top