Excel 2007- Loop through Cells, paste in lowest blank one

Hello Excel People - Can someone help me create a simple loop, I have 50 cells (need to paste in lowest cell) - I need this to occur:

-Is cell A1 empty? if yes - paste
-some other stuff happens...
-Is cell A1 empty? no, is cell A2 empty? - paste
-some other stuff happens...
-Is cell A1 empty? no, is cell A2 empty?, no, is call A3 empty? -paste

etc... to 50

Can someone provide some help.. I have not made loops before.Thanks



***

Thx for solving! Works great!