Results 1 to 10 of 10

Thread: Extract, Transpose and Fill automation in a survey

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 02-08-2014, 05:28 PM #1
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi

    Replace
    Code:
    ReDim arrOutput(1 To UBound(Data, 2) * 35, 1 To 10)
    with

    Code:
    ReDim arrOutput(1 To UBound(Data, 1) * 35, 1 To 10)
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    Reply With Quote Reply With Quote
  2. 02-09-2014, 03:15 AM #2
    Renczi
    Renczi is offline
    Junior Member
    Join Date
    Jan 2014
    Posts
    6
    Rep Power
    0
    Now it did the job! You just helped me be on track with my task. Deeply grateful!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. RefersTo:=Range [transpose(..)]
    By PcMax in forum Excel Help
    Replies: 1
    Last Post: 02-06-2014, 04:41 AM
  2. Transpose A Column Of Data In To A Table
    By gunjan.nasit in forum Excel Help
    Replies: 4
    Last Post: 05-20-2013, 12:33 AM
  3. Unable to Get ElementID In VBA IE Automation
    By ashu1990 in forum Excel Help
    Replies: 9
    Last Post: 03-28-2013, 11:58 AM
  4. VBA IE Internet Explorer Automation Through ElementID
    By mrmmickle1 in forum Excel Help
    Replies: 3
    Last Post: 01-22-2013, 06:20 AM
  5. Transpose data into Rows
    By vikash200418 in forum Excel Help
    Replies: 2
    Last Post: 04-10-2012, 11:02 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
  •  

Forum Rules