View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] mchangun@gmail.com is offline
external usenet poster
 
Posts: 2
Default Copy ata from several workbooks and paste into new work book

Hi All,

I am trying to copy a range of data from a series of opened workbooks
and paste them into a new workbook? How can I do this? So far, I've
figured out how to copy the range I want from one notebook, but that's
all. Here is my code for this:

Sub Macro1()
Range("A6", Range("A6").End(xlDown).End(xlToRight)).Select
Selection.Copy
End Sub

Thanks in advanced for any help.