find & replace macro

Hi All! I'm trying to do a range/replace on the activesheet, and am having trouble since the text has a quotation mark in it. I'm running into the double quotation problem and using """" isn't working. I'm trying to replace this: <test language="JavaScript1.1"...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hi All, I currently use a VLOOKUP function to merge details from one sheet into another, basicly I have a lookup table in the second sheet. The formula is like...

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...

Hi, I have a macro that opens a file, selects columns, copies and pastes on another file, saves file, then closes both files. I have to run this Marco every month. The way I run it every month is I go into the macro and find and replace the date with the new date. For example: C:My...

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...

Hello, I have a lot of word documents that need to be constantly updated. The most important thing that needs to be changed is the dates on the documents. Each word document has multiple pages, and each page has a date in the format MM/DD/YEAR on the top right hand, no headers. Also on the...

I have several workbooks that I would like to find and replace the contents of what is located in cell A2. Eg. find ="("&A2&")" replace all with "" The contents of cell A2 will be different for each workbook. Is there a way to change the Selection.Replace What: = to ( the text located in cell...

Hi, I'm quite new to VBA and I'm struggling to find a solution to this. I'm trying to delete the value from Column 2 and Column 3 if it contains the value in its corresponding row in Column 1. i.e. for the first row delete 94000 from Column 3, then loop to the next column and delete 50000 from...

Hi all, I am working on a cleanup macro to take the raw report our HRIS spits out (which is incredibly un-user-friendly) and give back a usable table. One part of it is going through the column of employee schedules and changing the codes it starts with to equivalent numerical values - it...

Hello, I would like to create a macro to find and replace parts of my model with data that the user chooses with input boxes. i have used this method before and it works well, there is just a missing link between the Input Box and Replace function Sorry if my formatting is not perfected this...

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...

Multi Find Replace Keywords with Abbreviation from Range - How to loop through a changing range This is my first post, so please be patient. I have a sheet with data in col B. This is the data to be updated. This VBA finds the keywords in col B that match the keywords in col N and replaces the...

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 :)

Please help me. I have an address in a cell for example - <tbody> 2215 Nw 36th St I need to search and find only Nw and change it to NW. The same goes for Dr, Us, Ne, St, Ste, Blvd and Dr How do I accomplish this in a macro? Thank you for your help in advance </tbody>

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...

Hey guys, I'm working on something for my dad. He has a spreadsheet (Sheet 1) of checks that have been written by his company during the month (currently at 3000 checks/rows). The range includes check number, account number, amount, and status of the check (either 'C' for Cleared or 'W' for...

How do I find the ' mark (the key just to the left of the enter key on the keyboard and just to the right of the ; key) and replace it with nothing? I have multiple (several hundred thousand rows worth) rows with cells that contain nothing but the ' mark which means I'm having trouble finding...

Hi. I am needing assistance in creating a macro to find and replace contents of cells from one sheet to another. Sheet 1 contains the data I want to put into Sheet 2. Sheet 1, in short, contains a schedule for a person. I want to find in the log list of schedules in Sheet 2 the schedule for the...

what i would like to do is copy a range of data "B185:AA185" and cell "b185" has a "date/value" and paste range "B185:AA185" to the right on new page the new page would have "dates/values" going down the side of sheet and if "b185" match then paste row "C185:AA185" i would like to have the...

Hello, I looked everywhere but did not find any tools to complete the task I want, so I need help to "convert" FW ruleset that look likes...