I am attempting to copy a range of cells, including the formatting, from one workbook to another. oWBNew is the new Workbook in a new excel application.
oWBCurr is the Workbook that contains the logic. The following line:

Please Login or Register  to view this content.
gives me this error:

Run-time error 1004:
Copy method of Range class failed

If I change oWBNew to oWBCurr.Sheets("Hdgs").Range("L100") this works.

Any ideas what the solution might be? Thanks