python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - find-replace

Why this find multiple and replace multiple script not working

I am not able to understand why this below script not working on google sheets, function Find_Multiple_Replace_Multiple(){ var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Data...
test-img

user18587694

google-apps-script

google-sheets

find-replace

Votes: 0

Answers: 1

Latest Answer

I found a similar question and edited the script to match your request, I tested it and it works. I’m sure there is a better way to do it but you can try this code. function runReplaceInSheet(){ var...
test-img

Lorena Gomez

Highlight text from one open parenthesis to the next open parenthesis

My goal is to highlight text from one open parenthesis to the next open parenthesis, if there is no closed parenthesis between them. Sub HighlightNestedParentheses() Selection.Find.ClearFormatting...
test-img

user10229348

vba

ms-word

infinite-loop

find-replace

Votes: 0

Answers: 1

Latest Answer

Try: Sub Demo() Application.ScreenUpdating = False Dim Rng As Range With ActiveDocument.Range With .Find .ClearFormatting .Replacement.ClearFormatting .Text = "\(*\)" .Repl...
test-img

macropod

VBA functions in one workbook, but not another, no errors found

I have an .xlsm workbook where this VBA (see below) interacts with a Word Document to replace field codes. Seems straight forward, and it worked great... Then I copied and pasted the code into a new ...
test-img

Rob_CH_

excel

vba

ms-word

find-replace

fieldcodes

Votes: 0

Answers: 1

Latest Answer

Using SendKeys usually is highly unreliable. To toggle the display of fields in word, you can use ShowFieldCodes, which is a Property of a View-object, and that is a property of a Window. With wordApp...
test-img

FunThomas

Access/MS 365 for Enterprise: Find specific text within a string in an Access table's column and update each instance

I have a file with 80K+ records that I compare to another file in Access to find address changes. The problem is that the data in the address columns are not apples to apples, so using queries I chang...
test-img

karin21201

sql

vba

module

ms-access-2016

find-replace

Votes: 0

Answers: 1

Latest Answer

You can use the find and replace option in ms access, CTR+F. look closely at the options I picked in the find and replace dialog box. I have attached the image of the table data before and after the f...
test-img

Sola Oshinowo

Posts

Questions

Blogs

Jobs