recursive

Dear community, good morning. I am new to this forum and hope you can help me. Here is my problem. Short version: 1. I need VBA to generate all possible combinations following a certain logic 2. Once a new combination is found, this combination needs to be evaluated with a certain function...

HI there I was wondering if someone can help me. I am working on a project that is incredibly hard to test, therefore we decided to come up with a simplified problem to take the first steps in resolving our problems. My problem is that I can't solve this simple problem using maths in excel so...

Hello, I have been searching for a solution to a problem for quite some times now, and I was hoping one of you have a great idea in this forum. I first like to appreciate any help and any reply to my problem. My problem is, I have an excel macro that does multiple thing for a report purpose...

Hello I'm trying to generate a report in PowerPivot which recursively calculates the total number of employees reporting to a Manager. I have a typical Employee table as shown below. If would like to filter by EmpID and the report should show me the count of the Employees reporting to the user...

Hi all, I'm trying to figure out a way to list only the first level of folders in a file structure. I'm accustomed to using the GetFolder method but how to do only one level is the question. For instance, if I had the following folder structure: C:\Base C:\Base\FolderA C:\Base\FolderA\Folder1...

Hi I am trying to learn about recursive programs but when I write a really simple one - to sum numbers up to n - I get #VALUE! error. Can someone please tell me what i am doing wrong. Function mySum(n) Dim n As Integer Dim result As Integer If n <= 1 Then result = 1...

Hello, After so many years of saying that there was no need to use VBA, I think I've reached my breaking point. Any help will be greatly appreciated! :-) Being a beginning at VBA, can someone please assist? I am trying to calculate the sum of a string of products under certain limitations...

I am trying to work out a formula to populate column D ie to add up the all the orders for that customer for the month ( the period of the data in the spreadsheet ). Just got no idea where to start. Any help would be great.

Hi all, My UserForm.Initialize() call SetControlEvents. This function purpose is to find all my ComboBox and TextBox controls and attach to them, a class module events. I use recursive because Frame and MultiPage are container. My Initial call to this function is ...

Hi, I adapted that code from the Excel help example for the Find function and from a guy from a forum somewhere. I want to transform that kind of BOM to a multi level BOM. 'This is from a guy looking for the same thing on another forum. FG1|SA1|1 FG2|SA2|1 FG1|CO1|4 SA1|SA3|2 SA1|CO2|3...

Hi, im trying to write a recursive function to reformat some data in excel. This is my first function i ever wrot using vb. I have used Scheme in school when learning how to write recursive functions. this is what i wrote Function f(cell) If cell = "" Then f = cell ElseIf...