!! copying and pasting without activating the destination sheet !! 
Author Message
 !! copying and pasting without activating the destination sheet !!

Hey All,

I would like to move information to a new sheet but I was hoping that
I could do it without having to activate the destination sheet.

I have the smae range of data coming from at least three different
sheets and would like to paste all of it into a new worksheet as one
big range.

Is it possible?

Thanks,

Mike



Wed, 04 Aug 2004 00:53:47 GMT  
 !! copying and pasting without activating the destination sheet !!
Dim vArr as Variant
Dim i as long
vArr = ("Sheet1","Sheet2","Sheet3")
for i = lbound(varr) to ubound(varr)
  worksheets(varr(i)).Range("A1").CurrentRegion.copy _
    Destination:=Worksheets("Sheet4").Cells(Rows.count,"A").End(xlup)(2)
Next i

Regards,
Tom Ogilvy


Quote:
> Hey All,

> I would like to move information to a new sheet but I was hoping that
> I could do it without having to activate the destination sheet.

> I have the smae range of data coming from at least three different
> sheets and would like to paste all of it into a new worksheet as one
> big range.

> Is it possible?

> Thanks,

> Mike



Wed, 04 Aug 2004 01:06:21 GMT  
 !! copying and pasting without activating the destination sheet !!
vArr = Array("Sheet1", "Sheet2", "Sheet3")
is what Tom means I think

Regards Ron



Quote:
> Dim vArr as Variant
> Dim i as long
> vArr = ("Sheet1","Sheet2","Sheet3")
> for i = lbound(varr) to ubound(varr)
>   worksheets(varr(i)).Range("A1").CurrentRegion.copy _
>     Destination:=Worksheets("Sheet4").Cells(Rows.count,"A").End(xlup)(2)
> Next i

> Regards,
> Tom Ogilvy



> > Hey All,

> > I would like to move information to a new sheet but I was hoping that
> > I could do it without having to activate the destination sheet.

> > I have the smae range of data coming from at least three different
> > sheets and would like to paste all of it into a new worksheet as one
> > big range.

> > Is it possible?

> > Thanks,

> > Mike



Wed, 04 Aug 2004 07:26:10 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Copy Sheet to another WB without activating it?

2. Copy/Paste sheet without all the conditional formatting

3. Copy and paste special values without switching sheets

4. Copy/Paste Special without making sheet visible...

5. paste to destination sheet without activating it - is this possible?

6. Copy/Paste Special selects the destination

7. Find last row before copying in destination sheet

8. copied formula returns #VALUE in destination sheet

9. How to copy cells to another file without copying and pasting

10. Want to copy a Web Page and paste to Word without copying hyperlinks


 
Powered by phpBB® Forum Software © phpBB Group