Help on ending Loop

[TimBrowne]

Hello,

I made a loop until is empty but somehow it keeps on running while the cells are empty on the tab Orden sheet, I probably have the do untill at the wrong place but am lost in seeing where it should be... Hope one can help.

Thanks!

Tim

Please Login or Register  to view this content.

[xlnitwit]

Hi,

I believe you might replace your code with this version

Please Login or Register  to view this content.

If you have a lot of data it would be faster to use an array to move the data across.