replace formulas

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

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

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

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

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, " ")...

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

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

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

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

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

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

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.

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

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

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