Results 1 to 2 of 2

Thread: Best way to read the contents of a cell line by line
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Mar 2012
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Best way to read the contents of a cell line by line

    Hello,

    I have been given a task to check the difference between 2 times in a transcript.
    The worksheet that I have been given has each transcript inside a single cells (1 cell per transcript). what would be the best way to read each line inside the cell?

    Do I copy the contents to a temp text file and read it that way or is there a way to read each line inside a cell ?

    I managed to code most things with a little guidance but i'm stumped on this one.

    any suggestions greatfully received

    thank you

    Andy
    Last edited by madmiddle; May 10th, 2019 at 06:52 AM.

  2. #2
    New Member
    Join Date
    Mar 2012
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Best way to read the contents of a cell line by line

    ok i've used the split function:

    Code:
    txt = ActiveCell.Value
        
    FullName = Split(txt, vbLf)
    but the cell contains blank lines in the text. How do i populate the array ignoring all the blank lines ?

Some videos you may like

User Tag List

Tags for this Thread

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
  •