All Questions
755
questions
0
votes
1
answer
46
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
...
- 11
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 ...
- 353
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 ...
- 23
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 ...
- 161
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:="...
- 11
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 ...
- 43
-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 ...
- 1
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
0
answers
14
views
VBA in Word look for a word in tables and if found copy the row
I need help writing a code that looks for a word in multiple tables in a Word file. If the word is found in the cell, I want to copy the row and paste it into an Excel file.
One challenge I have are ...
- 3
0
votes
1
answer
27
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, ...
0
votes
1
answer
45
views
Range.Replace IF another cell value is:
I am trying to use the find and replace function based on another cell value (in another column).
For example:
I want to do this change:
Columns("OEM").Replace What:="Aerostar Aircraft ...
2
votes
1
answer
48
views
Why FIND returns nothing with structured table?
Hoping someone could shed something on my line of vba script below and point out the error:
Sub findKeyword()
Dim tbl as ListObject
set tbl = activesheet.ListOBjects("myTable") 'containing ...
- 93