Hi Margs

To find the first empty row in column A you can use this:

EmptyCell=Range("A1").End(XlDown).Address

BTW: Showing the code you have made so far, will enable us to give a more
precise answer.

Regards,
Per

"Margs" skrev i meddelelsen
...
I am new to macros but have worked out how to transfer the results of a
calculation to a row on another sheet. When I clear the original data to
enter more how can I transfer the second lot of results to the next row
down
on the second sheet.
I discovered a GoTo under Edit but cannot fathom if this is where I need
to
be.
Many thanks
Margs