Refering with 'cells' to another worksheet

[Dexter666]

I Have the following code which should copy some cell values from another worksheet.

With Sheets("Zadanie").Range(Cells(iZac, 3), Cells(iKon, 3))
      .Copy
      Sheets("Objednavka").Range("bZacKopirovania").PasteSpecial  xlPasteValues
End With

The iZac and iKon are variables refering to first and last row numbers of the targeted range. But I get an application defined error while I am in the target sheet. When I re-write the code with absolute Range names, everything is fine.

With Sheets("Zadanie").Range ("C" & iZac & ":C" & iKon)

But what's wrong with the Range.Cells property? Why isn't it possible to refer with 'cells' to another worksheet?

Thank you for the explanation.

 

[shg]

Unqualified, your Cells references refer to the active sheet. So,

With Worksheets("Zadanie")
    Range(.Cells(iZac, 3), .Cells(iKon, 3)).Copy
    Worksheets("Objednavka").Range("bZacKopirovania").PasteSpecial xlPasteValues
End With

 

[Dexter666]

Thank you very much... I have much to learn...