i got this problem and would like to solve it, but i need yo - Page 2
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: i got this problem and would like to solve it, but i need yo

  1. #11
    Board Regular
    Join Date
    Mar 2002
    Posts
    73
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    it gives me a list of this: with #N/A selected:

    1510
    880
    660
    573
    481
    266
    249
    #N/A
    345
    #N/A
    361
    270
    117
    279
    215
    151
    152
    237
    15
    #N/A
    #N/A
    #N/A

    what does it suppose to do ???

  2. #12
    Board Regular
    Join Date
    Feb 2002
    Posts
    255
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I would split the column in two using the text to column feature (seperate the letter from the number) and then sort them based on the number. Then you can easily write a formula and concatenate them if you like. Here is some code that will do it (minus the concatenation).

    Columns(1).Select
    Selection.TextToColumns Destination:=ActiveCell, DataType:=xlDelimited, _
    TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=False, _
    Semicolon:=False, Comma:=False, Space:=True, Other:=False, FieldInfo _
    :=Array(Array(1, 1), Array(2, 1))
    Range(Columns(1), Columns(2)).Select
    Selection.Sort Key1:=ActiveCell.Offset(0, 1).Range("A1"), Order1:= _
    xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:=False, _
    Orientation:=xlTopToBottom
    Cells(1, 1).Select

    Is this what you're looking for?

    Dave

  3. #13
    Board Regular
    Join Date
    Mar 2002
    Posts
    73
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi there, i tried your code and i got the folowing results, but this is not what i want... (did i do it right?)

    Text Number

    xsxvb 15
    cvbvn 117
    cvbvn 151
    bvn 152
    ncvn 215
    vn 237
    dfx 249
    dsf 266
    gwt 270
    ncvb 279
    fdg 345
    cnnb 361
    bgfhfn 481
    dfghc 573
    hrhcvb 660
    sdfbvc 880
    sfds 1510
    sdfsdf #N/A
    gfbcb #N/A
    yrt #N/A
    dfghc #N/A
    ssfs #N/A

    pls let me know



    still waiting some more ppl to help me please?

  4. #14
    Board Regular
    Join Date
    Mar 2002
    Posts
    73
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have just test the text to column function and it is now working the way i want it to be.

    the main thing that i used is replacing all the #N/A to blanks or 0...

    but thanks guys, it is working now!



    u guys are nice and great

    Cheers
    LMF

  5. #15
    New Member
    Join Date
    Apr 2002
    Location
    Paul, Sydney Australia
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Where is the information coming from, are you typing the information directly into the cells and if so, is the information you type derived from other info within an excel sheet?

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
  •  

 

 
DMCA.com