| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy rows from another file
I'm trying to copy and paste special (values) into my active file.
The # of rows in this file will change so it won't be static all the time. Can anyone point me in the right direction on how to set this up in vba? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy rows from another file
Hi,
Here's a start Sub CopyRows() Selection.Copy Workbooks("myTarget.xls").Sheets("Sheet1").Range(" A1") End Sub With this you copy the current selection and send it to the file myTarget.xls, which is open, starting in A1 of Sheet1. Modify as needed. -- Thanks, Shane Devenshire "Secret Squirrel" wrote: I'm trying to copy and paste special (values) into my active file. The # of rows in this file will change so it won't be static all the time. Can anyone point me in the right direction on how to set this up in vba? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy the same raws of all sheets from about a 100 file to a new sheet of a book and save the file | Setting up and Configuration of Excel | |||
| Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
| How do i copy a scramble file with 20970 rows to excel? | New Users to Excel | |||
| Hide Rows - copy and paste only rows that show | Excel Worksheet Functions | |||
| EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel | |||
Linear Mode
