Results 1 to 21 of 21

Paste "Jagged Array" without looping

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-30-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    476

    Paste "Jagged Array" without looping

    Hi. I'm wondering if there's a way to paste a Jagged array to cells in a single pass? Here's the loop I'm thinking of?

    Sub Noono()
    
        Dim keekee(1 To 4)
        keekee(1) = MySummary.[a7:a56]
        keekee(2) = MySummary.[a57:a106]
        keekee(3) = MySummary.[a107:a156]
        keekee(4) = MySummary.[a157:a206]
        
        [c885:c1085] = keekee
    
    End Sub
    this relates in some way to the following
    HTML Code: 
    Last edited by cmore; 03-24-2017 at 07:57 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 01-22-2016, 09:21 AM
  2. copy data based on predefined condition and paste them to an "array"
    By shu001 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-27-2015, 03:09 PM
  3. Looping thru rows and copy cell values from "Inputs" sheet to "Output" sheet
    By hariexcel1987 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-02-2015, 11:32 PM
  4. [SOLVED] Need to modify the Paste function of this VBA Macro from "Paste" to "Paste Special Values"
    By zicitron in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-04-2013, 03:44 AM
  5. If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ...
    By Maria J-son in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2006, 08:25 AM
  6. What is Error "Method "Paste" of object "_Worksheet" failed?
    By vat in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-17-2006, 04:10 PM
  7. Replies: 1
    Last Post: 01-30-2006, 06:10 PM

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