replace formulas

  1. I

    VBA to replace an existing formula with new one

    Hi guys, I am new to the forum and new to VBA. I am trying to write a code that would paste values of existing formula in one cell, then change an different formula in another cell and it repeat for n times. This is what I have so far: Sub Macro1() Macro1 Macro For i = 6 To 29...
  2. A

    Replace current month in formulas and text to next Month in files in Folder

    I am having an issue with this macro. I am trying to change the Months (in formulas and text) from all the files in this folder to the next month. This is so that when I do the reporting I simply need to run this macro and it will update all the files in the folder. The issue that I am having...
  3. N

    Formula to replace data on several tabs

    Hi! I need to replace some data in Excel workbook on several tabs, but cannot figure a formula to cover all tabs. Can someone help? In my Excel I might have the same name (and I know they are really the same eventhough written differently) spelled in various ways like : John Smith John Smith...
  4. F

    Macro to convert formulas from 1 syntax to another

    Hello Excel Gurus, I am trying to write a macro which will search through an entire worksheet for a specific formula (excel add-in) and replace it with another special formula (excel add-in). The added twist is that the syntax for each formula is different. Details as follows: Formula A...
  5. B

    Use Replace function

    I am confused with the replace function. I have data in a cell "May,12,2015" I want to replace the first comma with a space but I keep getting errors with the code. Below is the code that I have MyString = Range(MyDateCol & MyDateRow).Value MyString = Replace(MyString, 4, 1, " ")...
  6. L

    A problem with the replace function

    Hi all I`m trying to select dynamic range and replace a letter within that range I identified the last row and column of the whole range by R and C respectively I need to start my selection from the 1-st row, 3-rd column , so I wrote this code: Range(Cells(1, 3), Cells(R, C)).Select...
  7. J

    Search & Replace text string within a formula

    I have a spreadsheet that has two worksheets: A summary worksheet -- which is just summarized data using formula calculations to do my year end report. While each of the calculations used to get the summary data is slightly different -- they are all some variation of the...
  8. J

    Replace part of file name in a formula based on sheet name

    I'm really hoping someone could help me out with this one. Here is my situation: I have a workbook with several sheets, all set up exactly the same. Each cell on a sheet is referencing the same file, however each sheet is referencing a different file. For example, this is one of the cells in a...
  9. L

    Macro to find and replace formulas with cell value

    Hi All Apologies if this has already been asked in the forum, but I couldn't find it from my search. I'm looking for a macro that will find all the formulas in a workbook (with multiple tabs) that specifically begin with "=HsGetValue" and replace it with the value of that cell - e.g. if a cell...
  10. V

    Replace spaces with forward slash

    Dear friends, How do i add forward slash (/) between first word and numeric value. For eg. AFRAM/101; AES/151 <TABLE style="WIDTH: 452pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=603><COLGROUP><COL style="WIDTH: 452pt; mso-width-source: userset; mso-width-alt...
  11. A

    Replace part of a formula in Excel by using Macro

    Hello everyone. :) Is anyone knows how to automatically replace part of a formula, which is a link on that formula? Right now, I'm trying to create a macro that would enable me to replace a link on a formula. The formula is shown below...
  12. K

    Macro question - replacing formula

    I have a spreadsheet where dates are entered in a6:a49 either manually or automatically if cells f6:f49 contains data (names of cities). I'm trying to do a macro that would put the formula =IF(ISBLANK(f6:f49),"",NOW()) in cells a6:a49 if that cell's value is erased/deleted.
  13. C

    Automate A Formula Replace

    I am looking for a way to automate updating an existing formula within a selected range. This is my situation: <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I currently have 12 adjacent cells selected. The formula in the first cell selected reads...
  14. D

    wildcard for numbers

    Hi, I need to delete anything in a column after two decimal places. For example: 09.14ADC01A should be displayed as 09.14 I know I can replace 09.14* with 09.14, but this number changes. Is there a way to specify a wildcard character to identify numbers only, and delete anything after...
  15. B

    Replacing formula with value

    Help me please!! I have a set of data which I need to partially paste values only. However, I don't want to replace all values. The vertical list of data includes sumif functions, sum functions, if functions and simple additions, divisions and multplications as well as blank cells. What i want...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top