Results 1 to 2 of 2

Thread: URGENT HELP NEEDED - TURNING LIST FROM ONE CELL INTO
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Dec 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default URGENT HELP NEEDED - TURNING LIST FROM ONE CELL INTO

    SEPARATE ROWS.

    IS THERE A FXN OR MACRO TO TAKE A COPIED OUTLOOK DISTRIBUTION (USING SEMI COLONS) INTO SEPARATE ROWS AS OPPOSED TO ONE CELL IN EXCEL?

  2. #2
    Board Regular PA HS Teacher's Avatar
    Join Date
    Jul 2004
    Location
    Rochester, NY
    Posts
    2,839
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Did you want something like this?

    Code:
    Dim myArr() As String
    Dim i As Long
       myArr = Split(";a;b;c;d", ";") ' replace with your own string
    For i = 1 To UBound(myArr)
       ActiveSheet.Cells(i, 1).Value = myArr(i)
    Next i
    Recent Draftee
    www.mrexcel.com/board2/viewtopic.php?t=199272
    Recently came across a Free 1 GB Storage/File Sharing Site www.box.net

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •