+ Reply to Thread
Results 1 to 6 of 6

Unmerge And Fill cells with Macro

  1. #1
    Forum Contributor
    Join Date
    07-18-2019
    Location
    iran
    MS-Off Ver
    2016
    Posts
    123

    Unmerge And Fill cells with Macro

    "hi
    i have excel file, that in table sheet1 changed to Result sheet with macro.(first unmerge then fill)
    please help"
    (i can't attach file?)
    Last edited by habib100; 07-18-2019 at 05:49 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,521

    Re: Unmerge And Fill cells with Macro

    Welcome to the forum.

    Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    07-18-2019
    Location
    iran
    MS-Off Ver
    2016
    Posts
    123

    Re: Unmerge And Fill cells with Macro

    ok
    thank

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,521

    Re: Unmerge And Fill cells with Macro

    Add your workbook to your next post here - do NOT start another thread.

  5. #5
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Unmerge And Fill cells with Macro

    How to install your new code
    1. Copy the Excel VBA code
    2. Select the workbook in which you want to store the Excel VBA code
    3. Press Alt+F11 to open the Visual Basic Editor
    4. Choose Insert > Module
    5. Edit > Paste the macro into the module that appeared
    6. Close the VBEditor
    7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

    Please Login or Register  to view this content.
    To run the Excel VBA code:
    1. Press Alt-F8 to open the macro list
    2. Select a macro in the list
    3. Click the Run button


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  6. #6
    Forum Contributor
    Join Date
    07-18-2019
    Location
    iran
    MS-Off Ver
    2016
    Posts
    123

    Re: Unmerge And Fill cells with Macro

    Thanks You

+ 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. unmerge and fill
    By cheesemeister in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-18-2018, 11:28 PM
  2. [SOLVED] Unmerge Cells and Fill down the Values in newly inserted Column
    By prkhan56 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2014, 11:21 PM
  3. Macro to unmerge and put previous cells value+Desc
    By gpcarthik in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-16-2013, 05:37 AM
  4. Unmerge and fill down
    By dahrius in forum Excel General
    Replies: 5
    Last Post: 02-18-2010, 06:11 AM
  5. macro to unmerge cells
    By paul_20k in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-27-2006, 02:30 PM
  6. [SOLVED] MACRO - Unmerge cells and delete blank columns, leaving data colum
    By Alex Sander in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-08-2006, 07:15 AM
  7. [SOLVED] How do I get macro to unmerge cells that have been previously merg
    By HankY in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-08-2005, 02:00 AM

Tags for this Thread

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