foreach

Hi All, How can I make the following structure faster or simpler? Simple running cumulative sum of elements in an array returning an array of the same size. I've heard using For Each should make things faster but the lag I'm noticing with the structure below is noticeable on a few arrays per...

A B C D E F G H I Z ALEX ALEX ALEX ALEX ALEX ALEX ALEX ALEX ALEX ALEX JACOB JACOB JACOB JACOB JACOB JACOB JACOB JACOB JACOB JACOB RYAN RYAN RYAN RYAN RYAN RYAN RYAN RYAN RYAN RYAN

Sorry if this is similar to previous posts. I can't quite find one that solves my problem. I am attempting to compile multiple daily data tables into a database containing several years of information. I want to skip my personal macro workbook, as well as the sheet I am pasting into. This code...

Hi everyone, I'm trying to get this work and I can't for the life of me figure out why it doesn't :( I've got a few workbooks in a folder, and if any of them contain "ValueIWant" in range A4:T4 in any of their sheets, I want to copy the range of A6:T500 into a summary sheet and paste it...

Hi, I am working in Excel Online and am wondering if there is a good way to implement a foreach loop. I do not believe Excel Online currently supports VBA macros, but if you know how I can add them, I'd be willing to work with them. I have two columns of data, A and B. A contains names, B...

Hey Guys & Gals -- Creating a template for Program Management and trying to add some VBA. New to VBA and what I thought would be straightforward is of course giving me a challenge. taskRange = all the potential rows in the chart, would like to hide based on user input (currently 1 column with...

Hello all! My name is Joe and I have a complex problem to solve that may prove a nice challenge for some of you excelperts! I have a document that I use to generate contracts by importing information from another program. But I would like it to do more. More on this Document Here...

Hi there, I have two tables in my DataModel. GL Account This table describes the GL accounts. Some of the accounts are totaling accounts, ie they sum the total of other accounts. Totaling accounts have a text string that describes which accounts they should include in their total, eg: "X" <-...

Hi all, I am having some problems in creating some code that will check multiple folders that are listed in cells on a sheet (2 folders per subject), whether the folder exists, count the number of files in each of them and enter the number of files into an offset cell. What is happening is...

Using the advancedfilter I find rows in my data which have certain criteria. I'd like to make a calculation where i subtract to cells in each of and sum the result. Using the code below creates a loop which runs through all visible cells in all rows. I only need to run through each visible row...

Hi & thanks for taking the time to click on my post. As the title suggests I'm having some issues with the ForEach row function. In an attempt to automate our company's extremely painful payroll function, i'm trying to create a function that will scrape a spreadsheet, as below, and for each...

I am new to visual basic and I have been using the record macro feature to try and learn how it works but I have run into an issue. I have a list of values in column J that varies in length per sheet and I want each cell in column J that has a value to run through a macro. Placing the value from...