Copy rows from another file

  • Thread starter Thread starter Secret Squirrel
  • Start date Start date
S

Secret Squirrel

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?
 
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.
 
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 Help to copy information from one row at a time to another sheet 1
Copy Row Heights 4
Macro to copy & paste-special-values data to selected worksheets 1
VBA - retrieve data on last create named range from previous inserted named range 0
Copy and pasting values of filtered rows 1
Filter, Copy and Paste 2
Copying data to the next blank row 0
Excel Issue with "Average" showing in Status Bar 2

Back
Top