nested Loop

If itemQTY1 = 4 I want this result

QTY 4
QTY 3
QTY 2
QTY 1

If itemQTY = 3

QTY 3
QTY 2
QTY 1

and so on.......


Here is the idea, but this code doesnt work because of the multiple Do's

Please Login or Register  to view this content.

I think that part of your problem is that everytime you write one row and decrement itemQTY1, you then go back to the top of the column to start searching for the next cell.
This kind of construct might be easier

Please Login or Register  to view this content.

I just realized that this is also a good example to show how to do the same thing without Selecting (i.e. faster). Declaring a range variable, myCell, and moving it as the Select was moving the Active Cell will achieve the same result without Selecting.

Please Login or Register  to view this content.

Excellent idea, as I hit myself in the head. I feel like such an idiot sometimes. Thank you, I will try it.