Set two loop values as a range.

[bsladecamacho]

I have a list of cell ID's that have a value set as 1 if it starts with a particular letter, then 2 if it doesn't.
What I need in my module is to run a 'loop until' that will find the first "2" in row "D:D" then set that as the cell1 in a range. Then, 'loop until' it finds the next "1" and offset (-1) and set that as cell2 in a range.
After that range is set I would run my code based on the range.

[daffodil11]

Perhaps:

Please Login or Register  to view this content.

[MarvinP]

Hi bsladecamacho and welcome to the forum,

Here is some code that may do what you need. It is hard to understand exactly what you want but see if this helps.

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Another:

Please Login or Register  to view this content.

[bsladecamacho]

To daffodil11,
The problem with this is that it is searching for the 2 in the wrong column. I already have a column with the 1's and 2's. What needs to happen is it look at first 2 select the offset (0,-1) and set that as the first range

[bsladecamacho]

Hi bsladecamacho and welcome to the forum,

Here is some code that may do what you need. It is hard to understand exactly what you want but see if this helps.

Please Login or Register  to view this content.

I made one tiny change. On the Dtop it is to select the cell above then first "2" found

Please Login or Register  to view this content.

Great help! Thanks for the help. It is greatly appreciated!