Copy rows to different sheet starting at a specific row

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.

Please Login or Register  to view this content.

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. I should mention that I will be copying mulptile rows so they should all be copied below each other. Any help would be greatly appreciated.

Also posted at: http://www.ozgrid.com/forum/showthre...goto=newpost**

One way

Please Login or Register  to view this content.

Thank you so much for your quick reply, AB33. This is my original code but I want to start the copy at row 1 on Sheet 2.

Please Login or Register  to view this content.

I modified it following your suggestion so it looks like this:

Please Login or Register  to view this content.

but I get an 'Application-defined or Object-defined' error on line:

Please Login or Register  to view this content.

My apologies, AB33. I realized a made a typo, RN instead of NR. I fixed it and your suggestion works perfectly. Many thanks, once again.

Mumps1,
You are welcome!

This may not be the best way, but I've used it before. If there is no data above. Have an inputbox to ask for a start row. Then: Sheets("Sheet2").Range("A" & startrow).value = " ". Then run your code.

Please Login or Register  to view this content.

Many thanks to you as well, John. I appreciate your suggestion very much.

You're welcome. Always glad to help and too learn. I did make a mistake in explanation, but the sample seems to clearify what I meant.