Creating an if/then loop which terminates at a blank cell
Posted by Kristian Fern on February 15, 2002 9:51 AM
I want to create an if/then loop that copies each cells contents in a given column to a cell which is used as a key for vlookups. I would start at the beginning of the column and progress down once cell at at time until the macro hits a Blank cell. How do I get the macro to step down one cell at a time and how do I get it to stop at a blank cell?