Copy doesn't work

[Demirion]

Hi, this code works:

Worksheets("Ark1").Range(Cells(1, 1), Cells(lRow, lCol)).Copy Worksheets("Ark2").Range("A1")

but I want to copy data from the second row it doesn't work and error is displayed "Run-time error 1004. Application-definded or object-defined error":

Worksheets("Ark1").Range(Cells(2, 1), Cells(lRow, lCol)).Copy Worksheets("Ark2").Range("A1")

What went wrong?

 

[Fluff]

It will only work properly for the sheet that you are using to calculate those variables. But as I said for further help please start a new thread. And this time please explain EXACTLY what you are trying to do & what is wrong.

 

[Demirion]

Well, that's the thing, there are many sheets in this workbook, so how to make the variables work for all sheets or maybe it's easier to do it without variables? There are tables in the sheets that I want to copy without headers and paste into the second workbook to the second row.

 

[Fluff]

Please start a new thread as instructed. This thread is closed.