+ Reply to Thread
Results 1 to 2 of 2

Grouping Rows with Range Variables

  1. #1
    Dan G.
    Guest

    Grouping Rows with Range Variables

    Hello.

    I'm trying to create groupings by rows, but using variable integer
    values in the range.

    For example, if I have:

    Rows("2:2007").Rows.Group

    And I want to use two variables where:

    nFirst = 100
    nLast = 200

    to designate the row values to my groupings instead of those values,
    what's the correct syntax? I should know this, but I'm having issues for
    some reason.

    Anyone's help would be greatly appreciated.

    Thanks.
    Dan







    *** Sent via Developersdex http://www.developersdex.com ***

  2. #2
    Nigel
    Guest

    Re: Grouping Rows with Range Variables

    Rows(nFirst & ":" & nLast).Rows.Group


    --
    Cheers
    Nigel



    "Dan G." <dgesshel@socal.rr.com> wrote in message
    news:e$CJAKMRGHA.2088@TK2MSFTNGP14.phx.gbl...
    > Hello.
    >
    > I'm trying to create groupings by rows, but using variable integer
    > values in the range.
    >
    > For example, if I have:
    >
    > Rows("2:2007").Rows.Group
    >
    > And I want to use two variables where:
    >
    > nFirst = 100
    > nLast = 200
    >
    > to designate the row values to my groupings instead of those values,
    > what's the correct syntax? I should know this, but I'm having issues for
    > some reason.
    >
    > Anyone's help would be greatly appreciated.
    >
    > Thanks.
    > Dan
    >
    >
    >
    >
    >
    >
    >
    > *** Sent via Developersdex http://www.developersdex.com ***




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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