loop until

  1. A

    Loop until IE textbox contain 6 letter

    What is the code for loop my code until IE text box is contained specific character which user tpye. Loop until capca is entered by user
  2. D

    VBA Loop to create Excel Sheet, save excel sheet to specific folder on computer and generate Outlook 365 Email with attached excel sheet.

    Hi All I am hoping you can assist in how i would be able to writeup a VBA macro code that can resolve the below issue. Summary: Looking to create a VBA macro that can check the vins in the attached sample excel sheet “MOND94 – BUGS CERT -Checklist” where it will identify each row through a VBA...
  3. J

    Loop with VBA and Last Value

    Hi all, I have two lists of data. One list is like this in a column: 1 2 3 4 5 6 7 8 9 10 The second list is like this: 1 2 3 How can I use the loop until function which will find the last value in the first list (10) and continue the list in the second column until the last value found in...
  4. J

    Problem Exporting worksheet to PDF in a loop

    Hi, I have set up a worksheet which is set to export (print) to a PDF file. However it is a form with changing values (form values changes before each export), that's why i have put the code in a loop. The problem is when i have to print (export) the worksheet multiple times excel gives an...
  5. T

    Loop Until and then once more

    I have written a macro that repeats a series of actions on a row and then drops down to the next row and repeats these actions (different variables though, so the actions are not a straight copy and paste). It loops until it comes to a blank cell in Column A. What I would like it do, after it...
  6. R

    How do you LOOP UNTIL a formula result equals a certain value?

    Hi, I'm using the 'Do' and 'Loop until' vba functions so that I can copy a formula down to a certain cell in the column. The only way of identifying this 'certain cell' is if I were to evaluate a formula based on the sum of a range in the column next to it, sum(RC[1],R4C100)=0, where the range...
  7. A

    Copy to ActiveCell and activecell.offset(0, 2)

    2 parts to this question: 2 Workbooks Copies Data from wb1 to wb2 make changes in wb2 and override this information in wb1 -- (This part I got) This part seems confusioning and i thought a loop would be way to go, but not sure how to begin. Data which is copied back is as follows in...
  8. A

    Animation ideas

    Hi all, I am very inexperienced with macros, but had a strange idea about writing animations in Excel by writing an automated scroll (please humour me!). For the animation to work, the cells must be scrolled through visibly. I have done this successfully using a continuation of the following...
  9. A

    Finding next available row and making data entry required

    Hi all, I'm attempting to write a macro that will "loop until", down a given column (column a) until it finds a blank cell. Once the cell is identified I would like the focus to be on that cell and remain there until an entry/input is made by a user. Perhaps even a message box when a user...
  10. P

    Simple macro ends after loop?

    The following are two examples of a macro that simply end after the loop. They seem to complete the loop properly, but instead of continuing on with the rest of the code it ERRORs out? I just need it to then go to the "RegCard" sheet then and stop. Any help would be greatly appreciated. Thank...

This Week's Hot Topics

  • separating multiple Proper names (uppercase letters) from a list
    I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
  • 'for' Loop
    Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
  • Open specific pdf in folder with vba
    Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
  • What is wrong with this For Loop code?
    I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
  • Data to match
    Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
  • Shifting Columns
    Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

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