+ Reply to Thread
Results 1 to 9 of 9

each cell has its own data in it vba

  1. #1
    Registered User
    Join Date
    08-30-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    95

    Lightbulb each cell has its own data in it vba

    Hello gang! I am looking for a more efficient way of doing this code attached is a copy of the file and its desired result RoOmIE 13-09-18.xlsx

    Please Login or Register  to view this content.
    Last edited by RoOmIE; 09-18-2013 at 05:15 PM.

  2. #2
    Registered User
    Join Date
    08-30-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    95

    Re: each cell has its own data in it vba

    notice also that at 10 and 11 there are 8 dots in front of the number also in the code there are some empty cells but i would like there to be just the right amount of cells .. i might need up to 20 columns if not more.. (not likely but it could happen)
    Last edited by RoOmIE; 09-18-2013 at 01:24 PM.

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: each cell has its own data in it vba

    What do you mean at 10 and 11 and 8 dots?

    There's no data in rows 10 or 11 and the maximum no of dots is 4.

    By the way, a quick way to do this would be to insert enough columns and then use Data>Text to columns... with . as the delimter and Treat consecutive delimiters as on unchecked.
    If posting code please use code tags, see here.

  4. #4
    Registered User
    Join Date
    08-30-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    95

    Re: each cell has its own data in it vba

    if you look in my code when there the number is 10 there are 8 dots in in front of it .. the file that i put with 4 dots is an example. When you get to the number 10 the number of dots are reduced to 8. if you wish i could post another example showing you the 8 dots

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    08-30-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    95

    Re: each cell has its own data in it vba

    RoOmIE 13-09-18-no2.xlsx



    here is anoter data file to show you what i mean

  6. #6
    Registered User
    Join Date
    09-18-2013
    Location
    Hungary
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: each cell has its own data in it vba

    Cells containing dots should be selected first.

    Please Login or Register  to view this content.
    Last edited by Fotis1991; 09-18-2013 at 03:51 PM. Reason: Pls use use code tags around your code as per forum rule #3.

  7. #7
    Registered User
    Join Date
    08-30-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    95

    Re: each cell has its own data in it vba

    Please Login or Register  to view this content.
    this line bugs

  8. #8
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: each cell has its own data in it vba

    Try
    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    08-30-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    95

    Re: each cell has its own data in it vba

    works again like a charm jindon thanks again!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] combing multiple cell data into one cell (show string of data in one cell)
    By EvenRtrsUsExcel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-13-2013, 09:00 PM
  2. UserForm data paste to cell, cell character limit cutting off data
    By mpkavanagh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-17-2011, 01:31 PM
  3. Linking Partial Data From One Cell If Data In Another Cell Meets Requirements
    By swordswinger710 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 01-20-2009, 12:09 PM
  4. Prevent data entry in cell A1 if there is data in a cell B1 and vice versa
    By westonkw in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-22-2008, 12:29 PM
  5. Replies: 1
    Last Post: 12-07-2005, 02:00 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1