recursion

I am trying to create a macro that looks through a column of data, and if the value of a cell is #N/A, select the cell that is in the adjacent column. It should keep going down the column until it reaches an empty cell. I believe the most efficient way to do this is to have the macro call a...

Hello, I am stuck trying to solve what may be a very simple problem. I understand logically what needs to be done I just don't have the knowledge for the best way to handle this much data and not make excel crash. I am currently limited with no access to utilize Pandas to solve this even...

Hello everyone, this is going to take a bit of background to explain the issue in detail. I've been working on this project for so long I'm going cross-eyed. It wouldn't surprise me if there's obvious problems that I can't see because my nose is too close to it - y'know? Anyway. The purpose...

I have a table with Bill of Material information in four columns; Parent PN, Child PN, Quantity, Units of Measure. Given a parent part number as an input I am returning the "exploded" or "indented" bill of material. Essentially that means I am returning all the children of the parent, all the...

Hi Folks, Basic issue: I have a requirement to rename many outlook folders/sub-folders and I thought I'd found the perfect outlook VBA code; however, I have two issues with it 1) it's changing the case of my outlook folders to lowercase 2) It's doing part matches. Detail The code below...

Hello Everyone, Happy New Year Using the below table i would like to determine % of corp and % of Ind mentioned in column E and F. if the flag is Corp then Corp% is 100% if the flag is Ind then Ind% is 100% Above two cases are simple and straight forward. But when the flag is fund then the...

Excel 2010 - I have data that is in the following format. It is sorted in date order, ascending. Excel 2010ABC1keyValdatenewKeyVal20-40872016-02-17 13:40:21.8430B410530-40922016-02-17 13:40:21.970044-61940-40872016-02-17 13:40:22.017044-61950B41052016-02-17...

The code is failing on the red marked line. Can someone please help me with it. <code> Private Sub Workbook_Open() Dim WS1 As Worksheet Dim WS2 As Worksheet Set WS1 = Worksheets("Sheet1") Set WS2 = Worksheets("Sheet2") Dim testCollection As Collection Dim SIZE As Integer, sortCol As Integer...

<tbody> 5 3 1 4 7 8 2 6 </tbody> I have a one line table of 8 numbers, and am trying to write code so that the output is a one line table of 8 numbers - yet they are sorted from 1- 8. is there any way to structure recursion in VB? any recommendations about solving this?

Hello, I've been working on this for hours, and I'm ready to ask for help. I'm a relative VBA beginner, and have been teaching myself over the past month. I know exactly what steps I want this program to take, but am having trouble implementing those steps in a way that is concise, because I...

Hello, I have been scratching my head over this for a while but i can't seem to find the answer maybe because I have not done any recursive functions in a very long time :(. I have the following columns. <tbody> Begin Shape1 End Shape2 Begin Shape1 End Shape3 Begin Shape2 End...

Public FS As New FileSystemObject Public FSfolder As Folder Public subfolder As Folder Public i As Integer Public existingRange As Range '--------------------------------------------------------------------------------------- Sub updateProjects() Dim strStartPath As String Set...

Hello, I am a total novice when it comes to VBA. I have been using a macro in Word created from pieces all over the internet (credit to a user named matt198992 for recursion script). The code prompts a user for folder, then runs a macro called PublishasPDF to all word files in the...

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

My project is the conversion of an investment management decision-making tool from Excel to Access. I have two Access tables: [tbl_POSITIONS] records the closing value of each position held at market close daily: eg: 12/15/12, AIGTX, 41.17 [tbl_RETURNS] records the date and amount when...

Hi, Each week I receive a list in excel with over a 1000 of numeric values, which need to be [hyper]linked to different pdf files located inside the same folder [ "C:\folder\"]. Last time, I had to do them by hand and that was not fun at all :laugh:. Could somebody please help me with a...

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

I currently have two columns of ids, employee and supervisor, and need to find what division the employee rolls up to based upon the division's Vice President. I initially have the VP ID and Division in two columns on the same sheet. If the initial supervisor is not found on the VP "table", then...

Hi, I have a 2D array of size x times y containing texts. Each element may contain either: 1) some texts, 2) the underscore, or 3) nothing. Like this (x=3, y =4): "john" "_" "black" "peter" "" "blue" "mary" "" "" "" "" "" Now i'm looking for a way to 1) ignore empty...

I am trying to write a recursive algorithm in VBA that can read data from a table in an Excel range, for example: <TABLE style="WIDTH: 109pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=144 border=0 x:str><COLGROUP><COL style="WIDTH: 53pt; mso-width-source: userset...