+ Reply to Thread
Results 1 to 3 of 3

Passing vba array result to excel sheet

  1. #1
    Registered User
    Join Date
    01-17-2015
    Location
    INDIA
    MS-Off Ver
    2007
    Posts
    85

    Passing vba array result to excel sheet

    Dear All,
    I am to transfer VBA array in to active excel sheet.
    There is TOTAL number of element (totalno). I get that from VBA. Now corrosponding to each number there is unique number ( noelement). I get it using VBA code.
    So I learn that I can define array as

    Redim noelement (totalno-1) as long.

    Now I want data in excel sheet in column.

    Suppose total No =10
    I want “noelement” in Column A start from A1 , as shown below. Header shold be named as ELEMENT IN CELL A1
    ELEMENT
    201
    203
    205
    506
    407
    879
    345
    666
    456
    876
    Please guide me to write VBA code.
    Regards,
    PN

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,451

    Re: Passing vba array result to excel sheet

    Hi,

    Does this give you what you're looking for?

    Please Login or Register  to view this content.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Registered User
    Join Date
    01-17-2015
    Location
    INDIA
    MS-Off Ver
    2007
    Posts
    85

    Re: Passing vba array result to excel sheet

    Yes Man,
    This is working. I was trying hard since morning 10.00 am,Now it is 6.45 pm.

    You have solved it.

    Thanks a lot.
    Regards,
    PN

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Passing data to array from another sheet
    By Recyler in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-16-2011, 06:36 PM
  2. Replies: 5
    Last Post: 03-28-2006, 02:55 PM
  3. [SOLVED] Passing sheet names to an array
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-23-2006, 06:10 AM
  4. [SOLVED] Passing array from Access to Excel function
    By Dale in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-29-2005, 03:05 PM
  5. Replies: 3
    Last Post: 08-15-2005, 12:05 PM

Tags for this Thread

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