Results 1 to 4 of 4

Concatenate with forced lineshift (CHAR(10)) - Not working in VBA.

Threaded View

  1. #1
    Registered User
    Join Date
    10-15-2014
    Location
    Copenhagen
    MS-Off Ver
    201, 2013, 365
    Posts
    42

    Concatenate with forced lineshift (CHAR(10)) - Not working in VBA.

    Trying to solved what should be simple.

    I have text I need to combine in one new cell, thru VBA.
    When entering the string manual in excel it works, once I use the same line in vba, is return with "name error"

    Tried TextJoin - cant get the CHAR(10) to work.

    Thanks for all your comming suggestions.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Remove CHAR(10) blank from CONCATENATE formula
    By OLLY-7 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 08-06-2023, 01:44 AM
  2. [SOLVED] Char (10) function not working
    By saigalp in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 04-01-2020, 07:16 AM
  3. Removing line space in Concatenate and Char(10) function
    By treesieg in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-18-2019, 11:43 AM
  4. [SOLVED] Concatenate with char(10) but skip blanks
    By chirag.patel22285 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-03-2014, 06:59 AM
  5. CHAR(10) not being recognized when using the concatenate function
    By AKM1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-15-2013, 10:14 AM
  6. Changing a single Char in a string to another ASCII char
    By goofy78270 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-15-2007, 09:45 AM
  7. [SOLVED] 8500 cells with phone number(7 char.), wishing to add area code (10 char.)
    By moparz@gmail.com in forum Excel General
    Replies: 6
    Last Post: 03-10-2006, 01:15 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