Shift down to next cell in column

[EMoe]

Hello!

I'm looking for a one line code to move down in a column to the next cell without specifying the exact cell in the code.

Ex.

Please Login or Register  to view this content.

I want to be able to go down to the next cell or range when I click a macro button.

Thanks!

[MickG]

Hi, This bit of code will do, but you can set your requirements to select the next cell after clicking "Return", in "Tools", "Options".

Please Login or Register  to view this content.

Regards Mick

[mudraker]

Please Login or Register  to view this content.

[EMoe]

Thanks for the responses! I tried both codes, and both work well.

Thanks Again

[Kinna]

Hi guys,

What I need to do is very similar, I need to show 3 months in a chart (jan, feb, mar), and then when I click the macro button, the range should move in row down and show feb, mar, apr (and the next click on the button should show mar, apr, may)...

Here is the code of my macro, could anyone please help to show me how can I fix it?