find & replace

Sub FindRiskWords() Dim oRng As Word.Range Dim arrExcelValues() Dim arrExcelValues1() Dim i As Long Dim x As Long Set objExcel = CreateObject("Excel.Application") Set objExcel1 = CreateObject("Excel.Application") Set objWorkbook = objExcel.Workbooks.Open("\\path") objExcel.Visible = False...

Trying to open a PDF that has a fillable text field and link it with a cell, this is the best i have found, but it just seems to be opening my PDF and not adjusting the text. Sub AcrobatFindText2() <o:p></o:p> <o:p></o:p> 'variables<o:p></o:p> Dim Resp 'For message box responses<o:p></o:p> Dim...

Hey all, I have a macro that will give errors in some formulas on another sheet. So i hope to do the following: Find: =ALS.NB(VERT.ZOEKEN(B3;#VERW!;8;0);"") Replace =ALS.NB(VERT.ZOEKEN(B2;Artikelgegevens!E:X;8;0);"") So i just want the error (=#VERW!) replaced by the original Vlookup function...

Hello there, I looked around and couldn't find an answer to this specifically. Basically I'm trying to write a macro that finds text that occurs in both the comments of a worksheet and a table (found on the "Translations" sheet). Then replaces the aforementioned text with the adjacent cell...

Hi Experts, Below is what I've tried to do across multiple worksheets in same workbook (except for Sheet1). The code supposed to insert additional column in each wsheet and put the wsheet name to all rows with data. Then after that need to find strip off the strings "N-" or "AT-" in that first...

Hello, Is there and way to code so that the Excel Find/Replace window opens, is resized to be bigger, and the window stays there waiting for user import. Macros doesn't like it Thanks

I am very new to VBA, but I am learning so please bear with me. I'm creating a "validation/reformatting" tool for a team at work. I am stuck. :( I want to create a code for finding a specific list of ASCII characters in cells and replacing them. For Example: If "Ä" appears in a cell, I want it...

Hi there, I've been puzzling over a bit of code for a while now. Below is my full code for reference. Private Sub CommandButton1_Click() 'Working in 97-2013 Dim FileExtStr As String Dim FileFormatNum As Long Dim Sourcewb As Workbook Dim Destwb As Workbook Dim sh As...

I have a list of thousands of URL's that I need to regularly edit and I have been manually doing this with a find and replace, but I would like to automate the work. Unfortunately there is very little consistency in the domain structure and a text to columns approach won't work. I need to do...

Hi, in column A I have email address: pawel.tom@gmail.com aqwe_12@yzf.pl audi_adm_2@audi.com In column B I want to get only: gmail yzf audi How can I do it?

Hello. In excel, after I search and click "find all", I want to see the matching adjacent column values in the results list (so I can compare the results). Is there a way for me to archive something like this? Or perhaps a software that does this? Thanks!

Hi, I'm using Excel 2013. I'm looking for a vb macro solution. I want to find <b>✔</b> in my worksheet & replace it with something else. However, when I paste <b>✔</b> into my vb macro code, the <b>✔</b> gets converted to <b>?</b>. So how do I search for <b>✔</b> in a vb macro? This is what I...

Hi, I'm using Excel 2013. I'm looking for a vb macro solution. I want to find all alphabets (a-z) in a column & replace it with something else. Instead of using Selection.Replace What:="a", Replacement:="something else", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False 26...

I searched the forum before posting, but I could not find an example specific to my situation. I need to geocode addresses, but they are brought in with apartment/unit numbers and I need to remove them before I can geocode them. Examples: <tbody> A B 123 Main Street #123, AB 4 1234 Main...

Hi Experts, I am really in need of yours help. I am using Excel 2007 Version. I have around 3000 rows of data in excel and in each row there is a text "AB10" I want all of "AB10" replaced with different series of words. "AB10" Replaced with "A1" "AB10" Replaced with "A2" "AB10" Replaced...

Hi all, Need a macro/vba/tool that allows me to find and replace in all opened excel files, at once. If not, an external tool that allow me to drag & drop files, because I have dozens of files in different folders. Can you help me? Thank you very much :)

So I'm doing a simple search replace anode = 123 With Range(Columns(5), Columns(5)) Set C = .Find(What:=anode, SearchFormat:=False) C.Value = newvalue End With How do I set my find so that I only return cells valued "123" not "1123" or "1239"? Thanks

Hi everyone. I'm having an issue regarding the below code. It is a macro that opens a workbook and basically find/replaces a piece of a formula in each cell and then saves to the next month's folder. Everything appears to work fine. But when I open the newly saved workbook in the Oct folder...

I want to have a find and replace macro for a spreadsheet that uses vlookup to get a file for a particular month The vlookup function will have a network path like For every month I need to find and replace the current month (Jun 14) with the next month's spreadsheet (Jul 14) but if it...

The first column in my spreadsheet has four different types of values "yes" , "no" , "see above" & "" (blank values) I would like excel to look at the first column and find values that say "see above". Then I want it to look at the cells above it and copy the first "yes" or "no" that it finds...