Use Do Loop While to change ActiveCell value : ActiveCell « Excel « VBA / Excel / Access / Word
Use Do Loop While to change ActiveCell value Sub DoLoopWhileDemo() Do ActiveCell.value = ActiveCell.value * 2 ActiveCell.offset(1, 0).Select Loop While ActiveCell.value Empty End Sub Related examples in the same category...