Nested Loops

[Rick_Stanich]

I seem to be having trouble creating a nested loop. It seemed simple enough in my brain holder, however, in real life...Well I am here aren't I.

Here is my code:

Please Login or Register  to view this content.

I have gotten myself stuck in a loop for the code in red.

I thought I was stepping from cell E6 of sheet3 and then cell J1 of sheet4 to each next respective cell. What I get is the first blank cell of "sType" is repeated on sheet4 column J for for X amount of cells.

I am trying to list all blank cells from sheet3 column E to sheet 4 column J.

Any hints, tips and or examples is appreciated. Humor is tolerated.

[DonkeyOte]

Rick, not quite clear ... you're looking to take values from Col A on Sheet3 where blank in E and paste to Sheet4 Jx where x is determined by first blank cell ?

Please Login or Register  to view this content.

If the above is the correct hypothesis the above may still not work pending the construct of E on Sheet3 - ie whether the "blanks" are real blanks or in fact formula Nulls - if the latter is the case the above method will not work.

[Rick_Stanich]

It works, thank you, I am going to have to study this one to understand how.