+ Reply to Thread
Results 1 to 4 of 4

Join and Merge Selected Selected Cells

  1. #1
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    266

    Join and Merge Selected Selected Cells

    I am using the macro below to join and merge selected adjoining cells in the same column (it merges the cells up to the top most selected cell).

    I am looking to expand it so that I can select cells in more than one column and it will merge each cell to the top cell in each respective column, but have come up with short. Any ideas on what I need to add? Thanks in advance.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Join and Merge Selected Selected Cells

    Try:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    266

    Re: Join and Merge Selected Selected Cells

    You rock!!! That worked. Thanks...

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Join and Merge Selected Selected Cells

    You're welcome!

+ 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. Loop backwards through selected range - delete entire row from selected cells
    By scottbass in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-20-2014, 09:21 AM
  2. Replies: 2
    Last Post: 08-28-2011, 02:39 AM
  3. Merge the contents of selected cells
    By hbsqn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-18-2010, 01:19 AM
  4. Merge the contents of selected cells
    By hbsqn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-11-2010, 01:28 AM
  5. merge selected cells
    By FlameKeeper in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-22-2009, 11:53 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