Need Help Copying cells into another workbook

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

I would like to copy the values in a range of cells that are being
referenced from other sheets in that workbook to a different workbook
that will run pivot tables. The macro will need to use the next
available row that isn't used yet. There are 7 Columns and 23 Rows.
Could someone please help me?
 
Dim rng as Range
set rng = Workbooks("Pivots").Worksheets("Sheet1" _
).Cells(rows.count,1).End(xlup)
activesheet.Range("A1").Resize(23,7).copy Destination:=rng
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy Multiple Areas from One Workbook to Another 4
Scattered array cells copy to scattered array cells another workbook 14
Cell values to an array, then array transpose to another workbook 8
Import multiple workbooks to current workbook in specified row number 0
Open four Wbooks, copy four columns from each to Master Wbook 16
VBA code for pasting links -- modifying RDB code for summary workbook 10
Copying cells and formula from closed workbook to all sheets in open workbook 0

Back
Top