H
I have a test: For K=53 to 6 Step -1, If the value in a cell is 0, then add a chart. If the value in the cell is not 0, then reduce the column number by one and test again. Repeat until true. If it is true in column 45, I would like it to remember column 45 so that I can use that column reference later, but outside of that loop. I tried using "K", but the loop continues to run down to 5. How do I stop the loop from continuing, or can I? How do I remember column 45?

Thanks for the help. This is a great newsgroup

Art