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