Thanks for the reply, I had thought of this technique and got it to work. I am only using a 2X5 array for this simple example, but my actual array is much larger (actually I have two 100,000 X 8 arrays) and I am trying to find a direct way to capture a range without excessive programming. Also the for and do loops seem to slow down the process.
Even the slightest performance improvements are a huge benefit when macros are capturing this much data. Thanks. On Mar 30, 3:27 am, paulwillekens <paul.johan.willek...@gmail.com> wrote: > Hi Jon > > What about following simple macro... > > Let me know if it suits you. > > Greetings > > Paul Willekens > '======================================================================= > Sub Runner() > > Dim aResult(4, 1) > > Dim nPos > > For nPos = 0 To 4 > 'Iteration code omitted > aResult(nPos, 0) = Cells(1, 1).Value > aResult(nPos, 1) = Cells(1, 2).Value > Next > > End Sub > '======================================================================= -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using "remove me" as the subject.
