+ Reply to Thread
Results 1 to 3 of 3

transfer data from vba array to excel

  1. #1
    Registered User
    Join Date
    11-28-2011
    Location
    zurich, CH
    MS-Off Ver
    Excel 2003
    Posts
    11

    transfer data from vba array to excel

    Dear all,

    I understand my previos post wasn't clear enough.
    Hope this one is.
    What i need to do is to writing all the values contained in myarray below to a1 in successive iterations to trigger s ome more formulas i have.
    I was thinking of using x,y to identifying x-sm rows and y- sm columns but clearly made a mistake: code below.
    Thanks for any assistance you can give, appreciate.
    Regards, n

    Sub Temp
    Dim myarray As Variant
    Myarray = worksheets("Sheet1").Range("b1:v50000")
    For 1 to 1 e 6
    Range("a1")= myarray(x,y)
    Next



    End Sub
    Last edited by zurich; 01-29-2012 at 07:42 AM.

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: tranfer data from vba array to excel

    Pleas use code tags (see the forum rules)



  3. #3
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: tranfer data from vba array to excel

    Please use code tags (see the forum rules)

+ Reply to Thread

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