Blank Row

[Mjoza]

Is there a short cut to go to the next blank cell in a column or row. I'm using excel 2007. I tried end+arrow down but it will take me to the last cell with data but I want to go to the one below it without having to hit arrow down again. I need to make a macro code.

Thank you in advance.

 

[AlphaFrog]

Here are several VBA examples for different situations.

Finding the Last Cell in a Range

 

[Mjoza]

Thank you so much.