All Questions
768
questions
1
vote
1
answer
41
views
VBA Backreferencing using Regular Expressions Find and Replace
I want to standardize the formatting of some text within a Word document using VBA and regEx. For example, my document would contain text strings such as "Qty #", "Qty (#)", "...
0
votes
1
answer
45
views
Find/Replace Row number within Formula
I have an Excel formula where I wish to change range row number found in a specific cell.
=SORT(UNIQUE(FILTER(CHECKLIST!K7:K120180,(CHECKLIST!B7:B120180=INVENTORY!H5)*(CHECKLIST!C7:C120180=INVENTORY!...
1
vote
0
answers
48
views
Request help marrying two VBA scripts together (Find/Replace)
Attempting to add Find/Replace to existing code
Starting with this piece of code which works to convert a .CSV to an .XLS File:
Sub CSVtoXLS()
'UpdatebyExtendoffice20170814
Dim xFd As FileDialog
...
0
votes
1
answer
25
views
Find the string (or most common string) associated with user-input reference numeral within a document
PROBLEM
I'm trying to make a macro which allows me to enter in a reference numeral (e.g., 102) and have the entire document be scanned for instances of that reference numeral. I want the code to ...
0
votes
1
answer
33
views
Edit VBA to scan a document and pick out the reference numeral that corresponds to a string, e.g. output "102" for "dog 102" in the document
My current code to do this works when all instances of the string in the document are accompanied by the associated numeral. However, where some instances of "dog" arent followed by "...
0
votes
3
answers
83
views
VBA | Find all "text" and change their font color Red
I want to find all the cells with text "Not Found", and make their font Red.
Any advise on how to do so?
String NotFound = "Not Found"
My program will call the subprocedure ...
0
votes
1
answer
70
views
Find value in sheet1, copy offset value, find offset value in sheet 2, paste text in offset cell
I have looked at a lot of different ways to do this and tried to incorporate their ideas into this sub but I keep getting different errors every time I run it. I am searching for "0" in the ...
0
votes
1
answer
33
views
VBA function FindInRow not always work - Find a cell in an excel row containing either text or date
Sometimes my VBA function FindInRow works, sometimes it doesn’t.
The VBA function FindInRow is used to find if a 'text' exists in an Excel row or not. If the text is found in the row, the function ...
0
votes
0
answers
16
views
How to perform a Find/Replace on a directory of Excel files in VBA [duplicate]
I am wanting to perform a Find/Replace on all the excel files in a single folder
(that I am prompted to select.)
This is the code:
Sub Find_Replace1() Range("A2:A100000").Replace What:="...
0
votes
1
answer
60
views
Find and replace text in Microsoft Word using an Excel spreadsheet
I have a Word document written in English. The English acronyms need to be translated to French.
I also have an Excel spreadsheet. Sheet1 has the English acronyms in column A, and the French acronyms ...
0
votes
1
answer
62
views
Find and Replace Word Doc from Excel Tables
I am trying to create an order form in excel that can be populated, then with the press of a button complete a word-based order form (that will save as PDF) to send to customers.
I know this isn't the ...
0
votes
1
answer
45
views
VBA issue with Find function
I'm trying to find the row of for a value within a certain range. This range is changing, so it is set up with variables. In the example below the range is set from row 1 to 441 and it finds the value ...
-2
votes
1
answer
58
views
create array of strings, then check occurrence of those strings in cells [closed]
I have a very long list of company names in a column A as strings. They contain “LLC”, “llc”, “limited”, “Ltd.” etc in all combinations. I need to create a list (dictionary) and check for the ...
0
votes
0
answers
43
views
Excel VBA code to Find and Replace not working properly
I wrote a Find and Replace Sub in VBA Macros to find specific strings and replace them with some numbers. There are 30 blocks of code but the block 10 and block 15 does not work. And example of ones ...
0
votes
1
answer
25
views
How to find corresponding name/value from cell on one sheet and subtract it's number from corresponding cell on another sheet
I need to find the corresponding name of a part and subtract it's number on another sheet, if there is a number to subtract (number greater than 0).
I need to spread this for every sum of parts, ...