how do I create a loop that doesn't do anything but go down a column a checking there is data in each cell and only stops when there is nothing in the next cell. What I have currently is a code that sorts out data but I would like the code to stop when there is no data in the next cell. I've researched that you can use isempty but I don't really know how to use it.

thanks alot