1. D

    Replace word loop

    Hello, I am trying to build some macro that would replace some word from a table, based on a list of words, and paste each time the table one after the other. Example: Cat1 10 Replace Cat Horse1 10 Cat2 20 With Horse Horse2 20 Cat3 30 Cow Horse3 30 Cat4 40 Dog...
  2. M

    Replace charts in a Word document at bookmarked locations

    Hi there, I have an Excel spreadsheet and a Word document that work in pair. The spreadsheet is reviewed and updated regularly so the charts there represent the most up-to-date information. On the other hand, the Word document which contains the same charts (previously pasted as pictures)...
  3. gfdwer2

    VBA Code for Replacing Row values by matching unique code

    Hi guys, need help finding VBA code for this. Please see pictures attached. For example (Picture 1) IF I input 5 in (Sheet 1, Range C4), THEN the values in Sheet 1 under Row 8 should replace the values in Sheet 2 at the right side of special code 5, since the special or unique codes matched...
  4. G

    vba to replace value with a value from another sheet based on criteria

    I have this VBA that imports a workbook("Sheet1"), instead of replacing the values each time I am trying to have a VBA to do it for me. The values change every so often, so it needs to be as universal as possible. I have no idea where to start for this. The correct values are in sheet ("Data...
  5. G

    VBA to replace last two values based on their value

    I have no idea where to start with this VBA, but I have this column that I would like to replace the last two values to "T1" if they are equal to "**". Any help will be greatly appreciated. Ex: Column1 Column2 Result Bob WWWBN** WWWBNT1 Tyreek IFRYTFF** IFRYTFFT1 Jumbalie WROTMD WROTMD
  6. A

    Macro only works in debug mode

    Hello all, I'm attempting to run a macro over multiple workbooks which clean up, and add additional data into each workbook. For the most part, this macro runs correctly, however, one section will only run properly if stepped through in debug mode. If run normally it will have no effect. What...
  7. B

    Mismatch Error w/ REPLACE Function

    Hello, I am working on a macro to edit a fixed width text file. What I want my macro to do is loop through each line of the text file (copy and pasted into column A) and replace a value IF the value of "RecordType" = 1. However, the line with the Replace function returns a mismatch error. Any...
  8. S

    VBA Replace needs Sheet to be active, why?

    HI My issue is it only replaces all instances on the ActiveSheet oSht.Cells should allow it to work on all cells on oSht Short Version Change: For Each oSht In ThisWorkbook.Worksheets oSht.Activate oSht.Cells.Replace What.... into For Each oSht In...
  9. The_Rock

    Random Replace Characters in a Word

    Hi Folks I've been scouring the net but without success. I'm hoping the genius's here will be able to help me :-) I'm trying to mock up some work for my daughter to help her with Synonyms and Antonyms. What I would like to do, if possible is: Column D looks at Column F (which will be hidden)...
  10. P

    Replace and Find VBA code for a command button

    Hi goodmorning all, hope you can help me place I have cells which sometimes has forexample -1, -4, -3 in them the range is cellsB24:P39, so what I do at the moment manually is CTRL F (find and replace) clickon replace tab – in find what enter (-*) and in replace with enter (0) thenreplace all...
  11. H

    Replace all numbers with zero, except formulas

    I have a specified range selected. Range(ActiveCell.Offset(0, -9), ActiveCell.Offset(0, -3)).EntireColumn.Select Now, I have to replace all numbers with zero in the above range, except formulas. Can anyone help me?
  12. M

    Creation of IP Address Ranges

    I am trying to automate the ability to create IP address ranges An example Cell A1 has the value of In cell B1 I want to keep the first 3 octets and replace the last octet with 10 (end result for B1 is In cell C1 I want to keep the first 3 octets and replace the last...
  13. davewatson86

    Date issues

    Hello all i have a report that is giving me dates in the format of DD.MM.YYYY i am trying to convert this to a date format that excel will work with but i am getting some strange tings happening. i have used find replace to replace . with / but some dates are showing in a format of MM/DD/YYYY...
  14. D

    Replace HYPERLINK formula with button

    I've created a link with the HYPERLINK formula which is using customer IDs from another cell inside the Hyperlink. Works like a charm. Now I've been trying to make the Excel a bit nicer looking. Is there any way to replace the links with a button or a button-like graphic so it doesn't just look...
  15. G

    Finding each cell where a style is used

    Hello, I am trying to find each location where a style is used and SELECTIVELY replace that style (one by one, manually) with another style. I am not trying to replace all usages of one style with another style, blindly. Is that possible? Many thanks. Keith
  16. T

    VBA to launch userform by selecting a cell

    Hello, I have data sets I want to have code for that if I select a specific column, cell it opens a userform. The data set starts with a number such as 9334231/1 below. It will always vary in length. then another number, just different, indicates start of a new data set. If I was to select...
  17. L

    i need to replace some values in a column

    Hello, first that all excuse me for my bad english ;( I need your help, im new with power BI I have a table named LECTURA that contains a column named SMS. The column SMS have a lot of values, and i need to change the value of a part of it. The values i need to change have the structure...
  18. J

    VBA for Copy/Paste

    Hello! I am struggling with a function to link to a macro that requires me to copy a set of values from one sheet to another, while these values depending on a certain month that I link, and then asking the user a Yes or No question on if they want to replace these stored values for that month...
  19. M

    Remove unwanted characters

    I have a list of phone #'s in the format 519-555-5551 410-555-5222 I would like to remove the dash so the output looks like 5195555551 4105555222 I've tried find and replace but it does not work. Any thoughts? TIA
  20. A

    VBA Code to compare Dates, then run macro to match colums

    Hi, Hope I can get some help with adding code to loop through the dates in column A of Sheet1 & compare them to the dates in Column A, Sheet2. If the date on Sheet2 is greater than Sheet1 run the MatchColumns macro. Sheet1 accumulates jobs with recommendations through out the year. Sheet2...

Some videos you may like

This Week's Hot Topics