Starting from the actual activecell, go to the next empty visible row

Hi, try this one (column E); a is a variable.

a=Activesheet.Cells(1, "E").End(xlDown).Row + 1

Hi AlphaFrog!

It worked perfectly! Thank you so much!

Now I'm curious... how exactly works the part of "xlValues, , , 1)"? what is the meaning of each comma and the number?

I'm asking because I have a keypad in this Excel, and when pressing the arrow "up" runs this code:

Please Login or Register  to view this content.

So, is there a way to use the same code you sent me, but instead of going to the next down cell, going to the upper next cell?

Hi hhhle, I just have used the AlphaFrog code and it was perfect! Thanks anyway for your proposal!

OK, in order to go up, I just did it my way and it works :D

Please Login or Register  to view this content.

Thanks you all!

Thanks AlphaFrog!

I even now have found another method that better covers my needs. I just leave it here in case could help somebody:

GO DOWN

Please Login or Register  to view this content.

GO UP:

Please Login or Register  to view this content.

Is basically the same code I had, but now I have added a condition that when the loop takes more than 0.5 seconds, stops the loop and goes directly to the next empty visible row