loop a macro

  1. D

    Help Cleaning up Font.Color Keycells Macro

    Hi all, I'm trying to change the font color in a range when the cell in column G changes. The macro below is only working for the first row (row 8). I imagine this would be easier as a loop but I couldn't figure it out. There are many different font colors and each cell already has...
  2. D

    Run continuously

    Hello everyone i have simple vba code to find a word in the worksheet but i have a small issue, when i find the word the cursor moves to the word but the small window where i type the text disappears , i want to run the program continuously until i press the cancel button and below is my code...
  3. V

    Looping through a folder and copying data in sheet 2 of a file.

    Hi, I am having a number of individual excel files in a folder. I want to add a Summary sheet in each of the individual file and save it. I've prepared the Summary sheet, it contains calculations and formulas based on Data sheet. I have one macro which loops through all the files in the folder...
  4. P

    Looping Data Entry Without Deleting Data Already Gathered - EXCEL VBA

    I'm trying to create a tracker based on the quotes that my employees are sending out to our customers. I'll need to have the information coming from their individual versions of the same quotation tool to a singular tracking workbook on a Box.com folder. I need the information inputs to be added...
  5. K

    VBA looping in excel 2010

    Looking for assistance with my current VBA Macro in excel 2010 that is to perform the following function. Based on what is located in column I on tab "Covers" it will got to the correct macro, once it runs the needed macro I am wanting it to loop thru to the next row/cell in column "I" until it...
  6. M

    VBA Memory Leak?

    Hi All, Im not sure if I can attach the whole file as an example but I have described my VBA setup below. Any VBA help to identify and correct my memory usage issues would be greatly appreciated! I have a SharePoint site that has hundreds of Excel files stored on it and I interact with them...
  7. R

    Using VBA and solver to fill a 10x10 table of values

    I'm trying to use VBA and solver to fill a 10x10 table of values. (I am a complete beginner to both VBA and these forums, so I apologize in advance for my inevitable blunder in this post.) My solutions table has years in Column A (A3:A12) and percentages in Row 2 (B2:L2). There is a vlookup...
  8. G

    VBA to allow user to run through userform again

    Hi! I'm a novice user to VBA; I really appreciate any help. I'm working with a userform; I've got a 'complete' button that transfer the textbox entries to specific cells on the worksheet. However, I also need to allow the user to hit the 'add another region' button and then be able to go back...
  9. S

    VBA IF then Loop help needed copy value to another sheet

    I am not familiar with VBA if then loops so I don't really know where I would begin to write what I need. here's the scenario: In sheet (1) If cell values in column (F) = 1 then, in that same row, copy cell value in column (A) and find the next empty cell and paste in sheet (2) column(B) the...
  10. D

    Loop through drop down list and then call other macros

    Good Morning. Anyone point out to me how to loop through a drop down list and then call another macro? Ex. Drop down list: Apple Orange Peach Mango Plum I want it to go to apple first, run a macro I already use have then move to Orange and run the macro again until i get to plum and stop...
  11. J

    VBA Paste Loop Question

    Hello, I am currently using the following code to pull in data from various websites. Sub Macro3() ' ' Macro3 Macro ' ' Dim Erw, Frw, Lrw Frw = 1 Lrw = Range("A" & Rows.Count).End(xlUp).Row For Erw = Frw To Lrw With ActiveSheet.QueryTables.Add(Connection:= _ "URL;" & Range("A" &...
  12. cvincent

    VBA to Search Column, Cut & Move Specified Cells

    I am using Excel 2010, and when I download data into Excel, the Totals Row doesn't line up with the rest of the data. The totals row ends up in Column A, while the data starts in Column B. I am therefore trying to create a macro that will search Column A for the word "Range", then select that...
  13. M

    VBA loop to open workbooks, copy and paste data

    Hi, I'm hoping I can get some helping with adding VBA code to my workbook that will merge data from multiple "detail" workbooks to one consolidation workbook. I have a list of file paths, names and sheet names in my consolidation workbook. I would like the macro to follow the first "detail"...
  14. J

    With inside a loop

    I continue to have a Runtime error 91 on this part of my code. I think it is because the loop includes a with. Can anyone help me? Am I putting the right things in the right place? Dim g As LongDim k As Long For e = 8 To y Set x = cs.Range("F:F").Find(fs.Cells(e, 1).Value) If Not...
  15. L

    VBA to loop code based on list

    Hello! I am working in Excel 2010 on a Windows 7. I have a set of data that I am trying to filter by each value in a column within the data set, save it as a new spreadsheet, and then email to a specific individual. I pulled out all of the values that I need to filter on and created a new tab...
  16. T

    VBA Combining Select Case with Private Sub for data management

    Hey guys, so I'm trying to fix a set of data column by column. So for example I have <tbody> Pass Score Age Gender No 40 21 Male Yes 92 19 Female Yes 87 45 Male No 69 60 Female Yes 72 37 Female </tbody> and I want <tbody> Pass Score Age Gender N 40-49 20-25 M Y 90-100 15-19...
  17. R

    VBA code to pop up multiple messages from multiple rows

    Hello, So i will have data updating in mutlple rows everyday. What i want to do is when the value "5" pops up in a column (k), a message will pop up saying something like "tote #49 (the tote number is in the same row, column H) will expire in 5 days". I want to do this also for 4, 3, and 2...
  18. G

    Excel Macro - Using IsNumeric and Cell IsEmpty as a condition

    If IsNumeric(ThisWorkbook.Sheets("sheet1").Cells(RowCounter, "A")) = True Then Call Method End If InitialRow = InitialRow + 1 Next MsgBox ("The End") End Sub Hi All, Above is the Code if the Column A has a Character go to Next line Works Perfect. BUT it Exits...
  19. G

    Excel Macro - If Cell contains a character go to the next row and STOP when Empty

    Hi All, I Am reading and excel sheet using macro. I have Put a condition already if the code come across ani ISNummeric = false Skip it to next line. I wanna know if the code comes a line where Column A B and C is empty Code should end DO Not go Beyond that row. Below is the table as per table...
  20. G

    Excel Macro - How do change my code If Cell is Empty The Code should End

    Hi All, I Am reading and excel sheet using macro. I have Put a condition already if the code come across ani ISNummeric = false Skip it to next line. I wanna know if the code comes a line where Column A B and C is empty Code should end DO Not go Beyond that row. Below is the table as per table...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top