find/replace

  1. T

    Excel VBA Range Scope for Find/Replace

    Greetings, I am interested in doing a Find/Replace on a specific range. Controlling the scope to Worksheet vs Workbook seems to be my issue. Doing a regular replace produces inconsistent results: Selection.Replace _ what:="abc", Replacement:="xxx", _ LookAt:=xlPart...
  2. B

    Need meaningless character

    Is there a character I can add to a VBA line that is meaningless to the code? I want to temporarily make several several lines the same, but be able to use "find/replace" on half of them later.
  3. jbesclapez

    Macro to Replace content of a cell.

    Hello Mr Excel, :biggrin: I have a range from A:G I have a column in I that tells what to find in the range I have a column in J that tells with what to replace. Those find/replace are in front of each other so : I1 is replaced by J1, I2 is replace by J2... The find/replace as match the full...
  4. O

    Find/Replace requiring drilling back to referenced file

    Good afternoon. I’m trying to figure out why - when I am using Find/Replace to update formulasthat are linked to other files – each formula requires me to go back to thereferenced file each and every time which may be several layers deep. These spreadsheets have hundreds of formulasin them –...
  5. H

    Find and replace for Word in Excel Maco not working

    Hi all- I am pretty new to visual basic to please excuse my lack of knowledge on correct nomenclature :) I have created a code in Excel VBA to open up a template word document and find/replace information in Word with the variables I have created in Excel. This code worked for one program and...

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