Selecting a strip of values in a column

[sapphire]

Hey guys,
Please look at the attachment to see my table.
I'm trying to write some code to iterate through the columns and select all the rows that have the info and paste by values later. I hardcoded the row values now but number of rows can change in the future. However, the new rows will be added between the "Dev't" and "Other" rows.

So I want m program to count the number of rows between "Dev't" and "Other" and copy all the contents in between.

here's the code I have so far:

Please Login or Register  to view this content.

[jtp]

Hi,

Try this out. Hopefully it is what your looking for.

Please Login or Register  to view this content.

[jindon]

Assuming the list is isolated from other data.
try

Please Login or Register  to view this content.