Hello,

MYQUERY:
I am using SHAPE command for MSHFLEXGRID.
I am trying to select and expand one row at a time.

WHAT I TRIED:
i am using command as
.CollapseAll
.RowExpanded = True
on MSHFlexGrid_Click event

PROBLEM I AM FACING:
The only problem is row number is actually considering all the expanded subset rows also

for e.g.
i have grid data as below in col(0) band = 0
#1
#2
#3
#4
#5
#6
#7
#8
#9
and so on (when not expanded)

1) i click #4 which has 3 subset rows
2) expand row words perfect
#1
#2
#3
#4--
|4.1
|4.2
|4.3
#5
#6
#7
#8
#9

3) but now if i click row #5 then instead of expanding row having data #5 , it expends row having #7
MY EXPECTED RESULT
#1
#2
#3
#4
#5--
|5.1
|5.2
|5.3
|5.4
|5.6
#6
#7
#8
#9

ACTUAL RESULT
#1
#2
#3
#4
#5
#6
#7--
|7.1
#8
#9

WHAT I KNOW
i know the cause why this is happening coz .row is counting all the expanded subrows.

i can fix this if i can allow program to consider row numbers of only band 0 rows / i can ignore subset rows / i can have a count of subset rows for existing expanded rows

hope i explain the issue.
any help?