Hi bopo,

Telling us the line you get the error usually helps However I see you are wanting to copy to sheet 2, but used both sheet1 and sheet2 in your sub above, so that is likely your problem.

I'd like to help you with specific code for your needs, so I will just ask this directly:

Say you select a cell in row 9 of sheet1, so you will want A9:K9 of sheet1 copied somewhere onto sheet2. Where do you want that copied to exactly?