I want to write a macro which will run in relative cell references
1. The macro starts at cell A1, say, activated by ctrl"k"
2. After the macro starts, it checks the content of cell C1
3. If C1 is a space, delete the cell content, then goto C2.
4. If C1 is not a space, skip to C2
5. Repeat step 3 & 4 up to C100
6. After all the 100 cells are checked and deleted if necessary, the macro stops at cell K1.
Thank you for your assistance.