+ Reply to Thread
Results 1 to 6 of 6

vertical range into an one-dimensional array

  1. 02-03-2013, 09:46 AM #1
    Bishonen
    Bishonen is offline
    Valued Forum Contributor
    Join Date
    03-17-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    2007/2010
    Posts
    555

    vertical range into an one-dimensional array

    Hi guys,

    a quick question: Is there an easy way to create an one-dimensional array from a vertical range? I know I could create a two-dimensional one first and then create another one with a for each... but perhaps there's an easier way? Transpose or something...

    Thank you
    If you think that my answer was helpful, please click on the "Add to this user's Reputation" button.
    Reply With QuoteRegister To Reply
  2. 02-03-2013, 10:16 AM #2
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,366

    Re: vertical range into an one-dimensional array 

    Please Login or Register  to view this content.


    In my test, I had a1 to a18 in cells A1:A18

    HTML Code: 


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 02-03-2013, 10:48 AM #3
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: vertical range into an one-dimensional array

    Misread post.
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  4. 02-03-2013, 10:59 AM #4
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,516

    Re: vertical range into an one-dimensional array

    Or something like
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 02-03-2013, 02:47 PM #5
    Bishonen
    Bishonen is offline
    Valued Forum Contributor
    Join Date
    03-17-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    2007/2010
    Posts
    555

    Re: vertical range into an one-dimensional array

    Thanks a lot to all repliers
    Reply With QuoteRegister To Reply
  6. 02-03-2013, 03:03 PM #6
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,366

    Re: vertical range into an one-dimensional array

    You're welcome. Thanks for the rep
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1