do loops

I have a double nested Do loop consisting of an outer and inner do loop. I'm having trouble passing values from the outer loop to the inner loop. A simplified version of my procedure is: Option Explicit Sub A() Dim t as integer t=0 Do lines of code Worksheets (1).Range("A1").Value = t Do...

I was browsing for a solution to my problem and found a thread that almost does what I need but not quite. http://www.mrexcel.com/forum/excel-questions/305014-rename-autoshape-adding-text.html This code creates 4 hard coded trapezoids and adds the text based on 4 preset cells. I need a...

Hi, for a given integer n I perform the following steps until I get to 1 if n is even then then next step is n/2 if n is odd then the next step is 3*n+1 for example. starting with 3 goes: 3-10-5-16-8-4-2-1 We say that 3 has a length of 8 Now I've written the following code: Sub...