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

[Noobz]

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!

[mewingkitty]

need to paste in lowest cell

Lowest?
Lowest as in how?

[Noobz]

My apologies... that should actually say, "paste in highest" blank cell...

for example... when this routine is called...

It will looked at column A, let's say A1,A2,A3 are full... this should paste in A4.

However, let's say A1:A10 are full, then A11 should be the next paste spot.

Thanks

[Trebor76]

Hi Noobz,

See if the following is what you're after:

Please Login or Register  to view this content.

Also, if 2007 is the standard version of excel you use, you should change your user profile to say this as it currently says 2003.

HTH

Robert