iteration

Hello, I apologise upfront if this is extremely confusing - i have struggled to put it into a nice clear format! however... I have 4 lists of data with each row containing two values; <tbody> Table 1 Val1 Val2 Table 2 Val1 Val2 Table 3 Val1 Val2 Table 4 Val1 Val2 First 52.3 0 First...

Hey everyone - new to the forum, hoping someone can help me! I have the following code for a function but am getting a #VALUE error when I enter the following arguments: EDate: 10/10/18 RDate: 23/01/18 Rent: 300000 Area: 10000 SC: 10 VC: 15 VG: 1 The function is supposed to iterate through a...

Good morning from NZ. I posted a question on this yesterday to do renaming/appending filename. I solved that. The problem I now have is that the code is not copying and renaming files to the new folder and yet when I run to cursor past the filenaming iteration it appears to be doing that. Comes...

I have about 30 files to copy to a new folder & rename the files with the date format ddmmyyyy added at the end of the filename before the Ext identifier ie filename.doc? to filename ddmmyyyy.doc? (I also need to modify actual files and want to do this via a macro iteration but one step at a...

Right so I've been working on this excel workbook for a couple months and all has been fine, up to now. I have recently been asked to allow for multiple user inputs to the same formula. Now just to let you know, one iteration formula contains approximately 10 worksheets to calculate correctly...

I have the following relationship x = (A - B*int(x/C)) Is there a non-iterative way to solve for x? By removing the INTEGER function, I can get quite close by not close enough. This is in a large model and it is a little tedious to wait for recalc which is driving the desire to go...

Hi there, I am connecting Excel 2013 to SQL Server 2012, trying to adding a sheet of data to a corresponding table in SQL Server. The code looks like this Dim MoviesConn As ADODB.connection Dim MoviesData As ADODB.Recordset Dim r As Range Set MoviesConn = New ADODB.connection Set...

Hi, I am looking for some help with developing VB code for the following steps for a financial model: (1) inputting a number into a cell which defines a scenario of assumptions (there are 5 scenarios i.e. scenario 1,2,3,4,5) (2) running a procedure to calculate the Interest during calculation...

Hi, I've never used macros before, so attempting to debug this thing is like learning a new language. I got the following error when trying to open a document: 1004: method 'iteration' of object '_application' failed When I attempt to debug, I get this code: Private Sub Workbook_Open()...

Hello all, I am looking for someone with experience building company financial statement models that use circular references to link the 3 financial statements. I am building a 5-year long-range model and basically the model keeps "blowing up" despite the fact that I turned on the iteration...

I have a spreadsheet that builds from existing data. The number of rows may vary depending on the data required, but all rows are filled and consecutive. I need to copy down a formula in a column from the top cell, but I can't get the logic to work in getting the Range().Select or...

A worksheet has data from machine oil pressure readings in column range A:D. The need is for a formula or macro to perform the following; Starting at row 1 copy the values of A:D to F:I every 5th row so that row 1 F:I will contain the values of row1 A:D, row 2 F:I will contain the values of row...

I am about to write a small macro to do a iteration calculation. I would like though for the user to select me a cell so that the macro uses the value in that cell to start calculations. Now, what I think would be the problem is how do I code a "time" or notice an action such as clicking in a...

I've had a very intriguing problem for a long time now, and am really hoping someone here can offer me some insight and hopefully a solution. Here's the deal: I have a simple function that pulls in a single cell value, one per row, stores it in a property of a custom type, and then does a...

I read Bill's "VBA and Macros in Excel 2007" chapter on Conditional Formatting. That said, I'm finding that iterating through the ConditionalFormats.Formula1 collection to not work as expected. For example, a cell shows in the User Interface the following three rules: Rule 1...

I am using DDE feeds in my Excel workbook in Sheet1 in cell addresses K1, M1 & S1 which are constantly being updated with the latest values. In Sheet2, in column D (starting with cell address D1), I am constantly updating with the latest value of K1, whenever a change in value takes place in K1...

Dear all, I would like some advice on whether is possible to solve in Excel the following problem and maybe some help with the solution. I have the following equation: Y = I * B(Y) (1) The magnitude of B depends on Y and I have a table of values of B vs Y Y...............B 110.00.......1293.75...

Hello, I am using Excel Pro 2003 version. I have an iteration sheet. I have 2 (two) variables which are Angle and Area. First I set the angle constant and have the iteration solved the area. Then I increase the angle and iteration solves the area for the new input angle. While I am doing the...

I am trying to use Solver to find the maximum investment growth for a business situation. The tricky thing is that one of the constraints is based on a cell that is derived from another cell, which in turn is calculated using Excel's "iteration" feature. To illustrate: One of Solver...