+ Reply to Thread
Results 1 to 3 of 3

Unmerge cells within range and copy contents to the new cell

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Unmerge cells within range and copy contents to the new cell

    Hello everyone
    I have in my attachment the sheet("Temp")

    In range("A3:AA7") there are a lot of merged cells
    I need a code that check every cell within the range and if the cell is merged cell >> the code to unmerge the cell ..
    This step I can do it ...
    But I need also to copy the contents of the merged cell to both the cells ...
    For example :
    In B3 (merged cell) the text "Science"
    After unmerging this cell , the text is in B3 only and as for C3 is blank .. Now I need to have the text "Science" in C3 also
    Hope it is clear

    Thanks advanced
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  2. #2
    Registered User
    Join Date
    10-10-2015
    Location
    Hoboken, Antwerp, Belgium
    MS-Off Ver
    2010
    Posts
    93

    Re: Unmerge cells within range and copy contents to the new cell

    Hi,

    Is this the way you want it?
    Attached Files Attached Files
    Greetings,

    Cheetahke

  3. #3
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Unmerge cells within range and copy contents to the new cell

    Thank you very much for this perfect solution
    It is awesome and wonderful

+ 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] Copy & Paste Cell Contents into Comments in another range of cells
    By Barking_Mad in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-12-2015, 06:38 PM
  2. Unmerge cells then copy content to only selected cells
    By zoenightshade in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2015, 11:44 PM
  3. [SOLVED] after unmerge, select cell to the left when range unknown
    By xcel_rider in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-28-2014, 03:36 PM
  4. [SOLVED] Restricting the column range in a VBA to unmerge cells and input value
    By wacky_diva in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-17-2012, 12:37 AM
  5. Commandbutton code to both erase cell contents, dismiss fill colour and unmerge
    By vdongen in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-03-2010, 10:14 AM
  6. Replies: 7
    Last Post: 07-04-2006, 03:20 AM
  7. [SOLVED] Unmerge cells and place contents of first cell in all cells
    By Amanda in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2005, 06:05 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