How to loop through rows and copy range?

Hi there,

Try the code below (assuming you are after a macro).
We are looping through all rows on the active sheet and write the address of the FIRST 'Error' for each row into the Immediate window.
With your sample data, if starting in cell A1, the result would be;
$D$1
$E$2
$C$3
$F$4
$E$5

Let us know how you go with this.

PS: please check the yellow banner at the top on how to upload a 'sanitized' sample workbook. That would make it much easier for us to see how your data is structured and test offered solutions.

Please Login or Register  to view this content.

You are welcome, and thanks for getting back to us.