Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Through a VB program, I'd like to modify some data for all rows that have
been grouped together using the .group method. Is there a collection, object, or some other method that I can use to find the group and traverse through it? For example, I have the below code to group some rows: Dim xlWB As Excel.Application Dim rng As Range Set xlWB = AppInstance Set rng = xlWB.Rows("3:5") rng.Group At a later point in time, I want to go back through the group and modify some of the information programmatically. What options are available? thanks - jimm |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Please post this thread a correct full method, method about | New Users to Excel | |||
Please post this thread a complete correct method, method about te | New Users to Excel | |||
GetObject method not work after Call Shell Method | Excel Programming | |||
Why QUIT method doesn't work after COPY method? | Excel Programming | |||
Group Method failed in macro | Excel Programming |