Why can I not copy a range from another sheet?

USAMax

Well-known Member
Joined
May 31, 2006
Messages
826
From another worksheet I can copy columns from:

Code:
                OWs.Cells(HdrRow, CCol).EntireColumn.Copy
and I copy cells and rows from other sheets so why can I not copy a Range?

Code:
                FWs.Range(Cells(FLRow, FSC), Cells(FLRow, FLC)).Copy
When I try I get the error: "Method 'Range' of object '_Worksheet' failed.
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
You need to qualify the Cells property as well as the Range property:

Rich (BB code):
FWs.Range(FWs.Cells(FLRow, FSC), FWs.Cells(FLRow, FLC)).Copy
 

Watch MrExcel Video

Forum statistics

Threads
1,099,330
Messages
5,467,976
Members
406,561
Latest member
Grappledog

This Week's Hot Topics

Top