+ Reply to Thread
Results 1 to 4 of 4

Concat_Range macro doesn't like 255+ character limit

  1. #1
    Registered User
    Join Date
    03-14-2014
    Location
    Mordor
    MS-Off Ver
    Excel 365
    Posts
    78

    Concat_Range macro doesn't like 255+ character limit

    Hello,

    I am having difficulty using the following macro to concatenate text strings over the 255 character limit.

    Please Login or Register  to view this content.
    Please see the example spreadsheet. Cell G2 works fine, even though I have a lot more total characters than G1. G1 is the one that I want to work properly. There is something it doesnt like in cell A1 that is causing the problem. The formula I am using in the cell is:
    Please Login or Register  to view this content.
    So, it places a bullet before the first cell, and also in front of each subsequent entry/cell (that isnt blank) and also puts the new cell on a new line. I really want to have everything show up in 1 cell. Any ideas what Im doing wrong, or is there another way to do this? Thanks!!!
    Attached Files Attached Files

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

    Re: Concat_Range macro doesn't like 255+ character limit

    I don't think the problem is the no of characters.

    When I step through the code the Evaluate part results in an array that includes an error value.

    What exactly is the function meant to do?

    Have you considered simply looping through the range passed to the function to create a dynamic array of the non-empty cells and then joining as required?
    Please Login or Register  to view this content.
    PS G1 has 350 characters and G2 has 140
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    03-14-2014
    Location
    Mordor
    MS-Off Ver
    Excel 365
    Posts
    78

    Re: Concat_Range macro doesn't like 255+ character limit

    I am very much a VBA-challenged person, so I really had no idea how to edit this (someone else helped me get this macro on this forum). The function is to concatenate multiple cells together into a single cell, and separate each cell by a user-defined (within the cell formula) separator (I'm using a bullet). What you have provided works like a charm! Thank you so much!!!

  4. #4
    Registered User
    Join Date
    08-28-2014
    Location
    *
    MS-Off Ver
    8
    Posts
    1

    Re: Concat_Range macro doesn't like 255+ character limit

    Uallah, it works! Thank u so much

+ 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. Character Limit
    By Dylan Moran in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-26-2014, 01:15 PM
  2. Macro Character limit/Condinue with same Shell
    By ussenterprise in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-10-2013, 12:53 PM
  3. Display Active Character Count + Limit Character Per Cell
    By euronail in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2011, 04:59 AM
  4. Replies: 1
    Last Post: 01-13-2011, 02:29 PM
  5. [SOLVED] 255 character limit
    By Noah in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-23-2006, 11:10 AM

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