Macro command to move cursor down

[s1awt]

Hi,

I am new to the forum but have been using Excel for some years, however I am strugling with a comand in a macro to move the cursor down 1 cell. My macro goes to a cell, then sends the cursor doen to the last row with an entry in it, I then want to move the cursor down 1 row to be able to copy data into it.

Many thanks

Andrew

[kendals]

hi, try and use the macro recorder, then view the code made from it.
This will give you a better idea of how to achieve what you want.

Regards
Kunal

[kendals]

here is an example, Make a new macro called Macro1 and test it.

Please Login or Register  to view this content.