Loop macro until empty row

Hello!
I have begun a macro that cuts data from the first cell in even numbered rows(beginning on row four), and pastes it into a new column on the end. I would like to be able to loop this process until two consecutive empty rows.
I am new to this, and would be very thankful for helpful suggestions!

Please Login or Register  to view this content.