Show your code.

Tim

"Chuck M" wrote in message
...
I am a VBA novice. I've created VBA code by recording Excel macros. I have
a
macro that copies cells from one worksheet and pastes them into another in
the same workbook. I want to run the macro repeatedly and have each
successive row in the target worksheet start one row below the previous
one.
I can pick up the row number from the source worksheet if that would help.
But I don't know how to convert it into a row number in the target
worksheet