I am having a little mental block (old age) finding a solution to this problem. I use the following code to copy entire rows from one sheet to another and this is pretty standard.
Assuming that Sheet2 is blank, this of course copies the rows to Sheet2 starting at Cell A2 and down column A. I would like to modify the code so that I can specify at which row the copy should start. For example, I might want to start the copy at A1 instead of A2, or at A10 instead of A2. Any help would be greatly appreciated.