View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
 
Posts: 812
Default Copy/Paste problem

You can copy 'Columns to Columns' or 'Range to Range', but not
'Columns to a Range'.
Try something like this:

Set sRange = WB1.Range("A1:M10")
Set dRange = WB2.Sheets(2).Cells(2, LC)
sRange.Copy dRange

Hth,
Merjet