merging cells in excel-VBForums
Results 1 to 5 of 5

Thread: merging cells in excel

  1. Jan 1st, 2009, 07:12 PM #1
    arshesander
    arshesander is offline

    Thread Starter
    Fanatic Member
    Join Date
    Oct 2006
    Posts
    694

    merging cells in excel

    im trying to merge a cell in excel using the code below but it doesnt work or there is no reaction.. hope any one can help me w/ this

    Code:
        Selection.Cut Destination:=Range("G6")
    Range("E6:G6").Select
    With Selection
        .HorizontalAlignment = xlCenter
        .VerticalAlignment = xlBottom
        .WrapText = False
        .Orientation = 0
        .AddIndent = False
        .IndentLevel = 0
        .ShrinkToFit = False
        .ReadingOrder = xlContext
        .MergeCells = False
    End With
    Selection.Merge
    Reply With Quote Reply With Quote Share on Google+
  2. Jan 1st, 2009, 08:40 PM #2
    RobDog888
    RobDog888 is offline
    Super Moderator RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    59,692

    Re: merging cells in excel

    Did you get that code from recording a macro?

    It shows ".MergeCells = False" which will not merge the selected cells.

    Thread Moved
    VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (VBA, VB 6, VB.NET, C#)
    Senior Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    • Star Wars Gangsta Rap • Reps & Rating Posts • VS.NET on Vista (New) • Multiple .NET Framework Versions (New) • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
    System: Intel Core 2 Extreme Ed., 2 WD Raptor 10K RPM 150 GB HDs RAID 1, 2 GBs DDR2 667 MHz RAM, 3 Viewsonic 17" LCDs, Windows Vista RTM, IE 7, Office 2007
    Reply With Quote Reply With Quote Share on Google+
  3. Jan 1st, 2009, 09:52 PM #3
    arshesander
    arshesander is offline

    Thread Starter
    Fanatic Member
    Join Date
    Oct 2006
    Posts
    694

    Re: merging cells in excel

    yes i got this to macro.. some code from macro works on creating an excel file?
    Reply With Quote Reply With Quote Share on Google+
  4. Jan 2nd, 2009, 01:33 AM #4
    RobDog888
    RobDog888 is offline
    Super Moderator RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    59,692

    Re: merging cells in excel

    You want to create an excel file now? But from where? Excel VBA or another programming language?

    Create Excel Workbook
    http://www.vbforums.com/showthread.php?t=442132
    VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (VBA, VB 6, VB.NET, C#)
    Senior Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    • Star Wars Gangsta Rap • Reps & Rating Posts • VS.NET on Vista (New) • Multiple .NET Framework Versions (New) • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
    System: Intel Core 2 Extreme Ed., 2 WD Raptor 10K RPM 150 GB HDs RAID 1, 2 GBs DDR2 667 MHz RAM, 3 Viewsonic 17" LCDs, Windows Vista RTM, IE 7, Office 2007
    Reply With Quote Reply With Quote Share on Google+
  5. Jan 2nd, 2009, 04:40 AM #5
    Siddharth Rout
    Siddharth Rout is offline
    Super Moderator Siddharth Rout's Avatar
    Join Date
    Feb 2005
    Location
    Mumbai, India
    Posts
    11,920

    Re: merging cells in excel

    The code posted in post 1 is absolutely correct to merge cells... Can you exactly explain...

    1) Where are you running the code from?
    2) Which sheet are you applying the merge in
    The poster formerly known as koolsid
    A good exercise for the Heart is to bend down and help another up...
    Please Mark your Thread "Resolved", if the query is solved
    Microsoft MVP: 2011 - Till Date IMP Links : Acceptable Use Policy, FAQ

    MyGear:
    Sony VGN-FZ27G with a triple boot between (XP+Office 2003+VB6), (VISTA+Office 2007+VS2008) and (Win7+Office 2010+VS2010) || Sony VPCCB-45FN with a Win7+Office 2010+VS2010. VM: (XP+Office 2003+VB6), (VISTA+Office 2007+VS2008), (Win8+Office 2010+VS2012) || Mac Book Pro (10.6.8) with Office 2011
    Reply With Quote Reply With Quote Share on Google+
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.