Results 1 to 5 of 5

How to GROUP in VBA

Threaded View

tuongtu3 How to GROUP in VBA 12-19-2013, 12:50 PM
p24leclerc Re: How to GROUP in VBA 12-19-2013, 05:30 PM
tuongtu3 Re: How to GROUP in VBA 12-21-2013, 02:10 AM
tuongtu3 Re: How to GROUP in VBA 12-21-2013, 10:04 PM
p24leclerc Re: How to GROUP in VBA 12-22-2013, 05:44 PM
  1. #1
    Forum Contributor
    Join Date
    08-14-2012
    Location
    USA
    MS-Off Ver
    Excel 2007, MS 365 (Windows 10 Pro 64-bit)
    Posts
    818

    How to GROUP in VBA

    Hello All,
    I'm looking for VBA/Code to Group and below is sample Macro I make:
    In column A2 is number "0" then start looking at cell A3 for number "1" and group together then stop at number "0" and so on until last row

    Sub Macro4()
    
        Rows("3:7").Select
        Selection.Rows.Group
        
        Rows("9:15").Select
        Selection.Rows.Group
        
        Rows("17:26").Select
        Selection.Rows.Group
    
        Rows("28:34").Select
        Selection.Rows.Group
    
    End Sub
    Regards,
    tt3
    Last edited by tuongtu3; 12-21-2013 at 10:03 PM. Reason: Solved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 01-18-2013, 12:45 PM
  2. Customised ribbon - displaying a group based on pressing a button in another group
    By micklloyd in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-15-2012, 03:55 PM
  3. How do I group worksheets (Lotus 123 function is "Sheet>Group Shee
    By Dave Peterson in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 09-06-2005, 09:05 PM
  4. How do I group worksheets (Lotus 123 function is "Sheet>Group Shee
    By jaking in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  5. How do I group worksheets (Lotus 123 function is "Sheet>Group Shee
    By jaking in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-30-2005, 10:05 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