Results 1 to 10 of 10

Add Range, copy & paste.

Threaded View

JapanDave Add Range, copy & paste. 04-01-2011, 04:11 AM
TMS Re: Add Range, copy &... 04-01-2011, 06:16 AM
JapanDave Re: Add Range, copy &... 04-01-2011, 06:30 AM
TMS Re: Add Range, copy &... 04-01-2011, 08:34 AM
JapanDave Re: Add Range, copy &... 04-01-2011, 08:39 AM
TMS Re: Add Range, copy &... 04-01-2011, 09:06 AM
JapanDave Re: Add Range, copy &... 04-01-2011, 09:41 AM
TMS Re: Add Range, copy &... 04-01-2011, 10:05 AM
JapanDave Re: Add Range, copy &... 04-01-2011, 07:35 PM
TMS Re: Add Range, copy &... 04-01-2011, 07:46 PM
  1. #1
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Add Range, copy & paste.

    I am trying to add a range to this copy and paste Macro, but I keep getting an error on the last line.

    Option Explicit
    
    
    Sub GetData_Example1()
        GetData ThisWorkbook.Path & "\test.xls", "Sheet1", _
                "A1:C5", Sheets("Sheet1").Range("A1"), True, True
                "A7:C10", Sheets("Sheet1").Range("A7"), True, False
    End Sub
    How do I add a range to copy more than one range?
    Last edited by JapanDave; 04-01-2011 at 07:34 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1