Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Copy _ Destination:= Range,Transpose?

  Asked By: Anita    Date: Jan 08    Category: MS Office    Views: 1377
  

I have:

CalcSheetv2.Worksheets(1).Range("B31:Q31").Copy _
Destination:=NEWSELBilling.Worksheets(1).Range("L65536").End
(xlUp).Offset(1, 0), Transpose:=True

but it doesn't work, presumably due to the Transpose.

How can I get it to work?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Brendan Smith     Answered On: Jan 08

You're not giving us much to work  with!
I take it that CalcSheetv2 and NEWSELBilling
are 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 one
workbook 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 combining
two different copy methods.
One is used to copy Filesystem objects, another would be used to
copy 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?

 
Didn't find what you were looking for? Find more on Copy _ Destination:= Range,Transpose? Or get search suggestion and latest updates.