Macro to select next down cell after pressing the down arrow keyboard

[Taislin]

Hi. I recorded a macro where i goes to the last non empty cell. Then i recorded in the same macro the movement of pressing the down arrow so it can select the next cell which is empty (so i can paste data through another macro). The thing is the macro recorder dont recognise the movement of down through keyboard and instead presents the code as a specific cell selection.
The code i got was this:

Please Login or Register  to view this content.

This last piece of code

Please Login or Register  to view this content.

is what the macro is giving me instead of selecting the next under cell.
How can i get a code to workaround this?

Thank you

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[Taislin]

Thank you a lot. I was almost getting the answer but you were fast.
I found this:
Move 1 cell right:
Selection.Offset(0, 1).Select

Move 1 cell down:
Selection.Offset(1, 0).Select

And i was already to start using this. But this code you gave (which is based in this) workes perfect.
Thank you

[TMS]

You're welcome. Thanks for the rep.