macro to retrieve Row Number of Conditionally Formatted cell

[roc_on_the_rocks]

Big fan of Mr. Excel for years, but this is finally my fist post. This should be simple for the pros, but I'm still crawling on VBA programming..

I'm tinkering with a macro to:

1) Scan a worksheet from LEFT to RIGHT and identify the FIRST Column containing the string "Engine_Speed". This may be named as "Engine_Speed_column".

2) Scan a worksheet from LEFT to RIGHT and identify the FIRST Column containing the string "DLC_ReferenceSpd". This may be named as "DLC_ReferenceSpd_column".

3) Scan the "Engine_Speed_column" from TOP to BOTTOM and locate the RowNumber of the FIRST Cell where Conditional Formatt .ColorIndex = 4 is TRUE and in the same row of "DLC_ReferenceSpd_column" the cell value is 700. Store this RowNumber as "start_row_700".

4) Loop (or something else) this criteria to create "start_row_800", "start_row_900" all the way to 2200, in 100 increments, by adjusting the sought value in "DLC_ReferenceSpd_column" from 700 to 2200.

Any help will be greatly appreciated!

 

[roc_on_the_rocks]

Hello folks ,

Could someone please help me here or at least give me some directions??

I sure appreciate your time and camaraderie.

THANKS!