| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Help Copying cells into another workbook
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need Help Copying cells into another workbook
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 -- Regards, Tom Ogilvy "Andrew" wrote in message om... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying cells between sheets in a workbook | Excel Discussion (Misc queries) | |||
| Copying cells from one workbook to another | Excel Worksheet Functions | |||
| Automatically copying cells to another workbook | Setting up and Configuration of Excel | |||
| Copying A Worksheet From Each Open Workbook to an new Workbook | Excel Worksheet Functions | |||
| copying cells to another workbook if the contain spacific words | Excel Programming | |||
![Andrew[_47_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
