do until

Hello all you helping ones. Thank you in advance for reading and for your help, really appreciate it i am trying to find the next day based on checked boxes there are 7 checkboxes: 1 is sunday (i based it on excels weekday values), hence 7 is saturday if the user checks e.g. the second box...

Hi everyone, so I've been working at this problem for a while and can't get the code to produce exactly what I need. I have a spreadsheet which is essentially going to print to an A4 sheet of 8 labels. On each label I want a customer name and order number, which is input via a UserForm. The...

I was thankful enough to receive a UDF from Rick Rothstein. https://www.mrexcel.com/forum/excel-questions/1101059-udf-sum-until-certain-column-not-blank-again-post5294214.html#post5294214 I was wondering if someone can help me and figure out a Do Until a certain range, I have to uses over 30 of...

Hello all, I am looking to make 1000+ reports based on a template. I have other sheets referencing the target city to update the data they report on. I have a master macro that calls on three other macros to format accordingly and save as "Location Report- Austin 1". After creating the Austin...

Hi all, I tried to summarize it with the title. I have two sheets I'm working with that i'll use index references for. I want to paste the value in cell "E1" from Sheet(1) to every cell in Col F of Sheet(2) if the adjacent cell in Sheet(2) Col A has a value. In other words: I have a name...

Hello, What is the command to do an action until I find a specific work in my column A? And once this word is found, stop the action. Thank you

Hey Folks, Long time reader, first time poster. I'm trying to have my code enter a formula in T8 (and T9, T10, etc.) until there is no longer a value in cell in row 8. It is based off another format so I need it to start on cell T8 so it doesn't pick up the headers (hence me trying to...

Hello! Is there a way to calculate a sheet until a cell is ≠ False in VB? I have cells Q92:V92 with IF statements "=IF(AND($O$101>98%,$O$101<99%),$B$99,FALSE" I just want the sheet to continue to calculate until one of those cells becomes true and displays a number instead of constantly...

Do Until thisBoolean = True... Will keep going "while" thisBoolean is False Do While thisBoolean = False... Will keep going "until" thisBoolean is True. They're like inverses of each other. Don't forget you can also use the NOT operator.

Geniuses, I am having a bit of trouble getting a piece of code to loop. I have a button that once clicked will do exactly this: If Duplicate_Find Is Nothing Then ActiveCell.Copy ActiveCell.Offset(0, 2).Select ActiveCell.PasteSpecial...

So I am trying to use .find() to to locate a string and write an adjacent string on a different worksheet if a cell adjacent to the string meets a criteria. If I find a string and the cell meets the criteria I am done at that point. I don't need to look any further. mouthful... this is what I...

Hello, Instead of using a pivot to calculate totals for my subcategories, I would like to use the sumIf function in Excel VBA. After I dumped my transacation (variable length each month) in Sheet1 (in dutch: "Blad1"), I'm aiming to calculate the totals on a separate sheet ("Som transacties")...

Hello, Instead of using a pivot to calculate totals for my subcategories, I would like to use the sumIf function in Excel VBA. After I dumped my transacation (variable length each month) in Sheet1 (in dutch: "Blad1"), I'm aiming to calculate the totals on a separate sheet ("Som transacties")...

Thanks in advance for the time. I'm trying to set a Do Until loop and after the range sets, VBA just skips the loop. I want a macro that hides all "0" value columns. What's actually in the loop can be wrong as well, but I just want to know why VBA skips the loop. My logic is that the range is...

Hi there, I have a loop which is skipping from the do until to the end without running through the code in between. Can someone see why it is not working? Dim LastRow As Long With ActiveSheet LastRow = .Cells(.Rows.Count, "a").End(xlUp).Row End With Do Until LastRow (LastRow=70)...

Hi, I'm currently working on a project in VBA where I need to write a sub that changes the font of the text in Column A for a given row based on meeting certain conditions. I've attached a picture of the worksheet I'm working with to make this easier to understand: In column A, starting at...

This is the goal: I need to get a huge column of numbers into a format to print for a binder. I have a macro that does it one row at a time, but there are 50,000 numbers in the column. I haven't gotten any loop macros to do anything for me yet. I also haven't been able to find an example of a...

Right out of the gate let me start by saying I’m no pro at this stuff. I’m really just a beginner with lofty ambitions and incremental growth in skill… Hence the post here… </SPAN> My Problem:</SPAN> I have a data set of an indeterminate amount of rows. It can be large. It can be small. It...

Hello! I'm having trouble with what should be a relatively simple macro. I'm trying to input a specific number of coordinates. The number of coordinates is determined by the user through an input box. When the row number equals the inputbox number, I would like the inputbox prompt to stop asking...

Hello, I am using Match in vba to select information from one workbook to another workbook. They are records with comments in three columns. I do not wish to copy the the entire row; just three selected columns for records in the old file can be found in the new file. The code below works...