Why can I not copy a range from another sheet?

[USAMax]

From another worksheet I can copy columns from:

                OWs.Cells(HdrRow, CCol).EntireColumn.Copy

and I copy cells and rows from other sheets so why can I not copy a Range?

                FWs.Range(Cells(FLRow, FSC), Cells(FLRow, FLC)).Copy

When I try I get the error: "Method 'Range' of object '_Worksheet' failed.

 

[Andrew Poulsom]

You need to qualify the Cells property as well as the Range property:

FWs.Range(FWs.Cells(FLRow, FSC), FWs.Cells(FLRow, FLC)).Copy

 

[USAMax]

Thank you Andrew, you came through again!