looping

hi everyone, I have a folder with subfolders that have excel files in them. I am trying to have a vba loop go through each of the sub folders, extract the value from Cell F1 from a specific sheet and then paste that value into another workbook. a couple of roadblocks: 1.) each folder has a...

Have a column C with a lot of data. Many of the cells contain spaces in the end. I want to trim each cell by using a macro looping through each cell. I want to practice looping. Is it possible to write a code which loops through each cell and removes the space(s) in each cell. Thanks.

there is going to be a data in A column of current sheet containing unique values. I want to add all these already existing unique values to a dictionary and use each of the unique value as a criteria for filtering in next sheet. How to add all the values of A column to the dictionary? and how...

Hello! I'm very new to VBA and have managed to create most of what I need; but am stuck on the hardest part IMO - Looping through the rows to create each chart. What I'm looking to achieve: Creating a chart for each row of data in my excel sheet. Each row of data has three years of monthly...

Hi I Want to build an excel file that looks like this: On column A the user put years (i.e: a1 is 2015 , a2 is 2016 , a3 is 2017) I want the macro will put on column C the year/month (i.e: c1 is 1/2015 , c2 is 2/2015 , c12 is 12/2015 , c13 is 1/2016 , c36 is 12/2017) I want to get 36 cells with...

Is there a code that I can add in my VBA that will convert selected columns to proper case without looping? columns = m, q, ae, and af.

I read that purely for speed purposes, you should use a For Each loop when looping through a collection. For arrays, use a For Next loop. What about for a dictionary? Which is faster? Thanks

Hi team, can anyone help me looping below macro for all the worksheet in workbook stuckup while looping Sub Loopforall() On Error Resume Next For Each cell In Range("C3:C250000,E3:E250000,Q3:Q250000,S3:s250000").SpecialCells(xlCellTypeConstants, xlNumbers) If Icell.Value >...

I have this question: Create a Sub with any combination of nested loops. This nested loop should take the baby girl names input (below) and print out every possible combination. These input names will need to appear in your workbook somewhere. Print out the combinations in the workbook itself...

A quick question for anyone that can help: How would I go about looping through a specific number of chart series? I am interested in scaling the primary y-axis using the first 7 chart series (the 8th series is on the secondary axis). Thanks

Hi guys, This is my code as followed, Sub Macro3() ' Macro3 Macro Sheets("MV filter").Select Range("A1").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy Sheets("MV-70%").Select...

Hello all, I am in need of looping the macro code below Sub Test() If Range("D2") = "Secondary" Then Range("J2,I2,R2,S2,T2").ClearContents End Sub The code above works great for the one line it is clearing but.. I need it to test conditions from 2 to 6000 on each column If Range("D2") =...

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

Hello Excel people! I'm making a promotional document for my company. It uses a combination of RandBetween and conditional formatting to make lights change color on a Christmas Tree, flames flicker on a Menorah ect. Right now I have a macro that will rerun all the calculations once a second...

I have a dataset where i am trying to select a range but there are a lot of blank cells in between and each time i run range("a2345:c3345").end(xlup).select It stops at the first blank I came up with a temporary workaround for this by looping this code Sub SelectRange() For x = 1 to 300...

Hi guys, i did some basic looping with below codes but it didn't give me the numbers running as my attachment. What should i do to make the number running in below range every time i insert it? sub test() for x=0 to 9 cells(x+1,1)=x+1 next x end sub

Hi All, Does progress bars with Excel VBA works only if there is a Loop? Is it possible to have progress bar while more than one macros running, without looping at all? Thank you in advance.

Is there a simple way of retrieving the worksheet name from the code name when the code name = "Sheet" & "1", "2", "3", etc. I can do it by looping through all worksheets, but there must be an easier way. Thanks in advance for any suggestions.

Hi, New to VBA here, getting error 424 object not found with this code after running, it runs only once perfectly but stops after 1 iteration. Consider "yyy" as all different variables (code I am using is below). Any help would be appreciated :) :) <tbody> Sub DeleteSpecifcColumn() Set...

I'm connecting to Access and opening a recordset for data which should match my Worksheet. Is there a way to check each Excel row against the recordset, without looping through every column? (They're in the same order on both).