I have:CalcSheetv2.Worksheets(1).Range("B31:Q31").Copy _Destination:=NEWSELBilling.Worksheets(1).Range("L65536").End(xlUp).Offset(1, 0), Transpose:=Truebut it doesn't work, presumably due to the Transpose.How can I get it to work?
You're not giving us much to work with!I take it that CalcSheetv2 and NEWSELBillingare objects that you've defined as Workbook objects?It looks like you're trying to copy a range of cells(B31 thru Q31) from the FIRST worksheet of oneworkbook to the last row (in column "L") of another workbook.Are both workbooks open?I need to do some testing, but I THINK that you're combiningtwo different copy methods.One is used to copy Filesystem objects, another would be used tocopy ranges.Have you tried recording a macro to do this and look at the result?Can you provide a bit more of the macro that precedes this snippet?