VBA Code - Excel - NEW USER

[michaelhilland]

I am a complete new user to VBA and Macros.

I am wanting to create a macro for copying a cell and pasting it to a new excel file. The process will continue. The difficulty I am having is when pasting a second, third etc time, it will paste on top of the original and not on new line.

So, every time I copy and it will paste onto a new line.

Thank you

[stnkynts]

You would need to identify that last used line, then reference that line and offset by 1. Example:

Please Login or Register  to view this content.

You can include a workbook reference if this is across different workbooks.

[HaHoBe]

Hi, michaelhilland,

you should alter the title of this thread to one that reflects the problem (no, not your problem ) according to Forum Rule #1.

Ciao,
Holger