+ Reply to Thread
Results 1 to 1 of 1

Using VBA to detect separate groups of rows.

  1. #1
    Registered User
    Join Date
    09-05-2014
    Location
    Detroit, Michigan
    MS-Off Ver
    2010
    Posts
    1

    Using VBA to detect separate groups of rows.

    The scenario is this:
    I have the task of automating the creation of a custom diagram in excel using data from existing documents.
    In order to properly organize the data, I must group certain data (objects) within other objects in a diagram representation.
    These data are already grouped via the feature that allows for grouping of rows in the existing sheets.
    I wish to use VBA to detect which rows are part of which group.
    I already have code that allows me to determine the group level. However, I need to be able to differentiate between groups, even if they are the same level and directly "next" to each other.
    I am unable to find anything using the "Google It" method, unfortunately.

    Thank you for any assistance.

    Disregard, I found out I had the answer all along.
    ID10T error...
    I can add to and manipulate the following code to do as I wish.

    Please Login or Register  to view this content.
    Last edited by Leith Ross; 09-05-2014 at 01:27 PM. Reason: Added Code Tags

+ 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. Using Pivot Table Groups/Rows for separate chart series
    By AntiPop in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-09-2013, 06:40 AM
  2. Macro to detect selection in 2 separate list boxes and react accordingly.
    By Kistler in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-28-2012, 06:15 AM
  3. Separate variables into different groups
    By narayanyr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-08-2009, 08:44 AM
  4. Separate Table Data and List Groups in Rows
    By Scott.h in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-31-2008, 07:57 AM
  5. [SOLVED] Separate Groups by Inserting Lines
    By ConfusedNHouston in forum Excel General
    Replies: 2
    Last Post: 10-17-2005, 11: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