do loop

ok so I've got this code which is aiming to work out the length of the first n collatz sequences. See: Collatz conjecture - Wikipedia, the free encyclopedia Essentially for a given integer x, the sequence is as follows: first term: x second term: if x is even, x/2, if x is odd, 3x+1 continue...

I'm trying to pull data into a template from a source tab matching by account number. However, having trouble when the account numbers in the source tab are not in the template. If its just one account number, or they are separated by good account numbers, the code below works, but if 2 or more...

Good Morning, I have a spread sheet with the following: <TABLE style="WIDTH: 314pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=419><COLGROUP><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><COL style="WIDTH: 48pt" span=3...

Hello, I am trying to repeat a Do Loop given a specific property return in an If Statement. For example, for the first part of it I have: Do r = ActiveCell.Row If r < 53 Then a = "C" b = r - 1 If Sheets(n).Cells(b, 3).Interior.ColorIndex = 15 Then...

I am trying to record a macro which does a Vlookup on between 12,000 and 18,000 cells over another worksheet containing about 900 entries. At the moment the process is terribly slow, i simply typed in the formula and copied it down to cell 18000. This was very time consuming so I then decided to...

I am trying to do a 'countdown' for the number of items in a list in VBA. I use (cell DA4), the below counta formula and would like the do loop under that to move down one cell (offset formula) and put in the formula (cell above -1). I want this loop to end when the activecells value = 2...

Hi, I have a loop that isn't working and it's beyond me what is causing the trouble. If anyone can notice what may be causing the issue I would be extremely grateful. I have two loops, the first one works fine (which is why I want to show it), and the second one is basically the exact same...

I am trying to get a Do Loop for the following problem: If a cell (in range (B5:B10) = "1" then select the 4 cells to the right of that cell (with the "1") and highlight them. next cell I have part of this but can't seem to get it to work....could someone please help me? Sub test()...

hello I have a list of names, some of which occur several times, with values attributed to the names in the adjacent column. I want a list in which the names occur once and the all the values belonging to the name appear in the row the name is in. I have code which almost does it, but not...

For those who know VBA well, this will probably be an easy solve: I would like the macro to loop through rows and highlight the cell in column G if the value is at least 2x greater than the value in the cell in column D. Right now I have a very long macro... but I'd like to change it so goes...