View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach Otto Moehrbach is offline
external usenet poster
 
Posts: 1,090
Default Copy/Paste problem

dRange.Offset(1)
HTH Otto
"Dan R." wrote in message
ups.com...
I know this is simple, but how do I shift the paste of dRange down 1
row? I'm pretty sure I need to use offset somewhere but I can't figure
out where.

LC = Lastcol(WB2.Sheets(2)) + 1

Set sRange = WB1.Columns("A:M")
Set dRange = WB2.Sheets(2).Columns(LC)

sRange.Copy dRange


Thanks,
-- Dan