How to move to the Cell below without ActiveCell?

Hello....How can I jump to the cell below every time a button is pressed without using activecell (because the active cell already performs another function), for example, if I am in cell A1 I need to move to cell A2 by pressing the button, then to the cell A3, and then A4 ...?

or

Press Button.......copy cell A1 .... paste value in cell D1
Button ..... copy cell A2 .... paste value in cell D1
Button ..... copy cell A3 .... paste value in cell D1

I think there is no way skipping the active cell. You have to use active cell in that case

Please Login or Register  to view this content.